Want multiple subreports, but only one is displaying

[coolcapybara]

I have 10 queries that filter and sort the same two tables in different ways (mostly matched/unmatched fields and find duplicates). I want these to appear on a report.

Unfortunately, when I use subreports, I get the following results (based on whether I add 1 subreport, 2 subreports or 3 subreports). Each subreport is calling a query for it's data :

1 Subreport -- works fine. Everything displays.
2 Subreports -- First subreport works fine, only label of second one appears
3 Subreports -- First works fine, 2nd and 3rd don't appear at all.

None of the queries called by the subreports alters the tables at all.

Any suggestions?

----------

Example:

Table "Statement1" has a field, "Amount"
Table "Statement2" has a field, "Amount"

Query "A" compares Statement1.Amount and Statement2.Amount, checking for unmatched amounts
Query "B" compares Statement2.Amount and Statement1.Amount, checking for unmatched amounts

Report "Report" has two subreports

Subreport1 displays Query "A"
Subreport2 displays Query "B"


No tables are altered, and both queries may be run at the same time, yet only "Subreport1" will show.

 

[Darrylles]

Hi,

Have you created (for testing purposes) 'duplicates' of the queries, where Q1 uses Q2 which uses Q3?

Are the correct results returned then?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk