1783057 - In Crystal Reports, is there the equivalent of the option 'result from another query' in query Panel like in Webi?

• Need to use result from another query in Crystal Reports
• Unable to find this option in query filter

• Crystal reports for Enteprise 4.0

N/A

This feature 'result from another query' present in Webi, is commonly referred to as “Multi-Query” and is not supported in Crystal Reports for Enterprise.

In order to have multiple queries in a report , the designer is required to use sub reports. Each sub report can have one query and contain whatever objects are needed from that query.

If a sub report will return a large set of records, it is best practice to place the sub report in Report Header or Report Footer sections to avoid them being run multiple times.  Alternatively the sub reports can be linked to a field in the main report which reduces the number of records returned by the sub report based on the value in the main report. In this scenario it is acceptable to place the sub report in a Group Header or Group Footer. It is not recommended to place the sub report in the Details as this will cause the report to be executed for every record in the main report and can cause severe performance issues.

result object another webie web intelligence , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem