Hello,
Being fairly wet behind the ears with Crystal Reports, I've been struggling with an issue of authentication. I have a Report, that is created in version 8.5....interfacing with a Sql Server 2000 database.
I access the report through our company's internal web site. (The website was created in Coldfusion and Apache)
The Sql Server housing the data is on a separate server than the server serving the website.
So.....everything works just fine, except the report requires the user to provide a username and password for the report, and the 4 subreports within it.
Our users would never tolerate having to log in 5 times for a single report....so I'm trying to resolve this.
Is there a way to embed a username and password into this report? I'll be happy to create a user to plant in the Sql Server database, if I could just figure out how to stick it in the report.
Thanks for any help.