Crystal requires DB Password

building reports crystal reports
1

The crystal report has been set up correctly through Publication Wizard so the username and password for the database connection does not have to be entered when the report is run. This works fine if the crystal report uses a table but this report has the Data Source with the properties of a table type of “stored procedure”. This is the only difference I can finds between the reports that request a username & password.

What am I missing?

Thanks
Bella

S0006318978 (BOB member since 2009-04-27)

2

You don’t say what your underlying database is so I will give you what we do.

We have several reports that report from stored procedures in SQL Server. We use SQL Authentication for all of our reports. We have logins specific for Business Objects. We have to set the login credential in the CMC in order for the users to be able to run the reports without having to supply login credentials.

Set up your login ID and password in the CMC. In the When viewing report section check the Use same database logon as when report is run option.

3

Thanks for your reply. I’m new at BOE Crystal Reports.
I hope this information can help.

The database is Oracle 9i. There is a main report called IO3016. This report calls two subrebports. As it turns out all three reports use oracle procedures not tables to obtain the data.

I have set the Database options in the CMC to reflect that when viewing the report “Use same database logon as when reports is run”. But this is not making any difference. When the report is run from Infoview it still asks for a username and password.

Do you have any other suggestions.

Thanks in advance.
Bella

S0006318978 (BOB member since 2009-04-27)

4

All of our reports that go against Oracle use a universe so I don’t have any specifics for how to set up Oracle stored procedure reports.

If you are on version 3.x, you could create a universe over your stored procedures and build your reports there. This would enable the universe to handle you connection information instead of having to handle the login information at the report.