using 2 views without any prompts

[ilya17]

hi,

i have a report that contains a subreport. the main report uses one view while the subreport the other. these views were created on the same database. the problem is when i start running the report, it prompts me to enter the servername, databasename, username and password.

btw, when i use one view, it doesn't prompt me for anything.

help would be very much appreciated as i've been pulling my hair out trying to figure this out.

 

[synapsevampire]

Technical information would be helpful, such as Crystal version, database used, connectivity, how much hair is coming out, etc.

A report should always prompt for the database when it's first run, or if you used a different type of connectivity it will prompt for each connection.

Try placing just 1 View on the report, save the report, exit Crystal. Open Crystal, open the report, and it wiull prompt for login (unless you have Windows NT Authentication, but then it won't prompt for either if you're using the same connectivity).

-k

 

[ilya17]

thanks for replying so soon, synapse

don't know what version as it's only imbedded in our dot net environment. but the databased used is sql server, and the connectivity is OLE DB(ADO). i'm not really familiar with this stuff.

anyway, we login at the start to access the database application created by C# so everytime i access a report with only one view, i don't have to login anymore. the problem is when i add a subreport which is in the same database it again prompts me. this is what i want to eliminate.

any suggestions?

oh btw, i think i already have a bald spot on my head.