Sunday, March 11, 2012

Crystal Report in VB.net Why Server Login?

I have created a report in VB.Net and use Crystal Report viewer to view it...but when I try to display the report it asked for a login to the server. I am using Intregated Security for all my other db connections in my application...how do I get that for the report?
Thanks,
CathyI've noticed that a report will ask for a database log-in, even if it was saved with data, and isn't automatically refreshed, if the database that the report was connected to when it was created, is not "locatable". I noticed this because when working at home, I would be prompted, and at work, I would not be. If I changed the data source (at home), it would no longer prompt for log-in info.|||I am at work and I'm not prompted when I connect to the same data for my forms...only with Crystal...
Thanks,
Cathy|||Cathy,

Don't know if this might apply in your situation, but, the thread "How to load a database name at runtime" http://www.dev-archive.com/forum/showthread.php?t=288950, shows people providing the log-in info just before the reports are opened, by coding it into the program. That doesn't really answer why, but it sounds like a workaround.

john

No comments:

Post a Comment