Customer wants to build a report which connects to more than one data source, but the data comes back incorrectly.
Having multiple databases in the database expert is not supported.
In order to use multiple datasources the user needs to combine them into a single command object. To make a command object do the following:
- Open the Crystal Reports report designer click Database, click Database Expert.
- Choose a connection to a database you are using (which contains the parent table) and an option will show up called Add Command.
- Double-click Add Command and a text box will show up to enter in the SQL which will connect the multiple datasources.
- After entering in the SQL click OK and you are now able to use fields from all of the datasources.
The SQL statement changes slightly from Crystal Reports XI to Crystal Reports XI Release 2 when reporting from multiple datasources. For more information please see Note 1220152.
command object, multiple datasources, sql , 4301255 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem
SAP Crystal Reports XI ; SAP Crystal Reports XI R2