cancel
Showing results for 
Search instead for 
Did you mean: 

Connection string of CR reports

Former Member
0 Kudos

Hi Gurus,

Kindly help me in getting the connection string used in the Crystal Reports.

Crystal reports coung is more than 350 reports.

Will the Query Builder will split the results by connection string.

how can i find the different connection strings used for these reports.

is there any work around....

Kindly help me

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

In QueryBuilder, try this query:

Select ,SI_ID, SI_NAME, SI_PROCESSING_INFO from CI_INFOOBJECTS where SI_KIND = 'CrystalReport'

The connection info will be a sub-property of SI_PROCESSING_INFO.  There may not be a true "connection string", but all of the elements except the un-encrypted password will be there.

-Dell

Former Member
0 Kudos

Hi Dell,

Thank you for the reply,,,

Is there a way we can change the connection string of all the 350+ reports automatically

or do we need to change them manually.

Thank you for help !!!

DellSC
Active Contributor
0 Kudos

You would have to write code using either the Java or .NET SDK to do that automatically.

-Dell

Former Member
0 Kudos

Hi Dell,

Are there any 3rd party tools that can do this task.

Thank you for the reply........

DellSC
Active Contributor
0 Kudos

I'm sure there probably are - a good place to start looking for one is at http://www.kenhamady.com/bookmarks.html.

I can't direct to to any specific one because I have a utility I've written that pulls this info.  Unfortunately, I can't just give it to you as it was written for my employer.

-Dell

Answers (0)