prompt twice for connection 1

[fsreport]

Hello
crystal 9.0
MS SQl
i have a report and it has the same database server but 2 different database
sample
server RRQAFSDB1
database
LM_Fund_Space
LeggMason_Space

both are ODBC system DSN and used the same user id and password how can i get my report prompt only once for the user id and password for both databases

thank you

fsreport

 

[IdoMillet]

You could switch to Integrated (NT) Authentication instead of SQL Server authentication. With regular (SQL Server) authentication, that's the standard behavior of Crystal and I don't know of a way to change it.

Alternatively, there is at least one 3rd-party viewer (see list at:

http://www.kenhamady.com/bookmarks.html)

that would prompt the user for just one login in such a scenario.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com