Multiple Queries in one Report

[Former Member]

What is the best way to show the data of 2 queries in one report?

[Former Member · Accepted solution]

The Queries are independend.

So no joins will be required.

[abhilash_kumar · Accepted solution]

Hi Frank,

Perhaps you could subreports as well!

One query in the Main report and ther other one in the subreport.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

thanks for that hint!

But will the results of the queries then be displayed on one page?

[abhilash_kumar · Accepted solution]

The depends on the volume of the data!

-Abhilash

[abhilash_kumar]

Hi Frank,

It purely depends on the reporting needs I would say. You could simply add the two queries, create joins in Crystal Reports and drag the required fields in the details section.

The joins in this case, however, would be executed by Crystal Reports, unlike when the report is created off a Relational database.

-Abhilash