cancel
Showing results for 
Search instead for 
Did you mean: 

Common datasource in SAP Crystal 2013

Former Member
0 Kudos

Hello,

I am using SAP Crystal Reports 2013 and oracle stored procedure as a source to crystal report. While creating report, we select new datasource-create connection->Oracle Server-->Then select the schema and the procedure and create the report.

But the problem , i am facing is whenever I make changes to report, everytime i need to go to CMC, give database configuration again to the report.

Is there any way that I can use a common data source, so that i can point all my reports to that source and dont need to give database configuration everytime when I change the report.

Regards,

Nikhil

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Nikhil,

Go to CMC > Right-click the Report > Select 'Refresh Options' > UNCHECK 'Default database logon information'.

This will prevent the password from being overwritten each time as update is made to the report.

-Abhilash