cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal report w/SQL databases

Former Member
0 Kudos

I am using crystal reports 11.5 and would like to create a report using more than one SQL database. I have been creating reports for a single database but ideally would like one report that can be run on multiple databases at once. For example I would like to combing database ABC & XYZ or run the report only for ABC or only for XYZ. Is there a way I can create a datasource that has more than one sql database?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

If you are using BO as your enterprise, you can create a business view by creating Dynamic Data Connection to these datasources.  Base on Business View you can create a crystal report.  While refreshing it will ask for a connection (like parameter selection) you can select whichever datasource you want to use.

or

You need to create two reports and insert as sub reports in a main report,  give a parameter selection to user to choose databse, based on selection you will have to suppress the other one and show the results in your report.

Thanks,

Sastry

Former Member
0 Kudos

Thank you for your reply. We are in the stages of creating a union view on the SQL databases, but do you know that when you refresh the data if you can choose one database or multiple databases at once? Our goal is to one report for multiple databases at once but they to always have the option to run it for one database too. Thanks very much.

Former Member
0 Kudos

Hi

In crystal reports desiger there is only one way to chage connection or datasource for other tables is Set Datasource location under Database menu.  We don't have any dynamic data connection selection option availbel while refreshing the report.

Or

You try to create a stored procedure and in that accept a parameter from user and based on user input try to extract the data from relevent tables.

Thanks,

Sastry

Answers (1)

Answers (1)

former_member183750
Active Contributor
0 Kudos

Perhaps with subreports and you suppress what ever subreport you don't need.

But normally, you'd do this using either the .NET or Java APIs.

- Ludek