Grant access to a database using a master user in Crystal reports
We have a newly created database. We are creating Crystal reports using tables from that databaase. I am being asked if we can create the crystal reports with the credentials built in so access would not have to be gramted for the individual users. They want anyone to be able to run the reports. Is there a way to do this? Is there a way to avoid setting up an ODBC connection on everyone's machine that would run the reports?
Crystal does NOT store the logon credentials in the report however if you are using CR Server or an equivalent product to run reports you can store the logon credentials when you publish a report.