More than one dataset in a Quick Report

[StevenK]

I have a Quick Report set up and am looking at displaying data from more than one dataset (not linked in any way). Is there a way of doing this using the Report creation itself or am I looking at doing it programmatically ? What I want is one set of data from Query1, some whitespace and then data from Query2, then from Query3, etc.
Am I able to do this ?
It's been a long while since I've used Quick Reports and am re-learning with it - so may be overlooking the obvious.
Thanks in advance.
Steve

 

[schu]

StevenK

I remember doing this before and it was quite simple. But I cannot find the source now.

However have you tried just having two separate queries, setting the parameters for the queries, set both queries to active, then calling the report.

In the seport, just have a separate section with a DBText fields from the second query.

I remember it should be as simple as that.

Try it first, and I will try to find my source.

 

[StevenK]

Thanks for the suggestion. I've resolved the issue now - what I did was to run an initial query to obtain the IDs of the groups I wanted to use in the report, running an additional query to obtain the data that I wanted to display in the groupings and then set up an appropriate master-detail.
Steve

 

[StevenK]

The best way of doing this has been found to add the appropriate number of TQRSubDetail bands to the QuickReport and set the 'DataSet' property for each of these to one of the datasets. This allows more than one dataset to be displayed in the report. In addition multiple bands can be used within (by setting their 'Master' property to the SubDetail band) these sections - such that we can set groups. etc. for each subdetail dataset.
Using this method we are now able to generate reports that are based on more than one unrelated datasets.
Steve