on 04-05-2012 7:57 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.