Crystal 2008 double login

[kyzina]

Hello people,
We are testing Creystal Reports 2008 and the problem we have is: When enter the parameters I have to choose the data sort selection and then I am directed to the normal log. Any ideas?

 

[kray4660]

Not quite understanding. Most of the time when we run a report and it has parameters, it will prompt us for the parameter then prompt us for the DB logon. Is this what you are saying?

 

[kyzina]

When I bring up the report and enter the parameter, I receive the screen regarding the Data Source selection , when I pick the Data Sourt Selection then it asks for the database login.

 

[kray4660]

Does this report have subreport(s)?

 

[kyzina]

No. Also when I tried shcedule the reports on BOE I have to login twice: when I enereing the prompt and regular login..

 

[fisheromacse]

I have not tried this with any other connection type, but if you are using an ODBC connection, you can go to the Database menu, choose Set Datasource Location, choose ODBC and then use Enter Connection String. The connection string will contain the driver type, the server IP, the database name, the user id and the password and will be formatted like: Driver=SQL Server;Server=192.168.1.100;Database=Lotsatables;uid=UserName;pwd=Password
replace every value after a = with the one specific to your database. click Finish, not Next. Save your report. You should now be able to run it without getting a database password request.