We have some reports that contain multiple datasources that are not related.
One source is a Command [SELECT Statement].
The other source is a database field [DB Instance] selected by browsing the database table using the Database Expert. This field is a string containing the database instance [DEV, SIT, UAT, PROD]. It really has no association with the Command Select statement.
Originally, the 2nd source was added to the report as described above, but it appears that when the Command SELECT statement does not return records, the DB Instance field is blank.
To fix this, we created a local variable in the main report and joined it to a subreport where the DB Instance database table/field was selected using the Database Expert. This works correctly.
I am just hoping that some can explain why the original approach did not work.
Is there an implicit join between separate datasources?
IP Logged
