cancel
Showing results for 
Search instead for 
Did you mean: 

Database Configuration options not available for Crystal in CMC

chris_robertson
Participant
0 Kudos

In the CMC, we right click on a Crystal Report and choose Database Configuration. I want to set the option 'When viewing and scheduling report:', but this option is grayed out. I want to set it to 'Use same database logon as when report is run', but it shows 'Use SSO context for database logon (viewing only)' and won't let me change it. How can I make this field editable?

FYI - We installed a fresh copy of 4.2 SP3 and migrate a few reports from 4.1 using Promotion manager. The migrated reports in 4.2 are the ones we are experience the issue on. They are Ok in 4.1.

Thanks, Chris

View Entire Topic
DellSC
Active Contributor
0 Kudos

What type of database connection is the report using in Crystal itself? Was it set up to use "Integrated security" on the connection? If it was, you won't be able to change this in the CMC without updating the report to use a manual login on its connection.

-Dell

chris_robertson
Participant
0 Kudos

It only happens for the reports to an SAP source: BW or ECC. Those that attach to SQL server have this options available. I'm not familiar with integrated security. I'll look a little closer to see if that could help us figure that out.

Thanks.