Query 1 is empty, so it is ignoring Query 2

[farmcock]

I have a report with two queries. Query 1 returns Auto Payments and Query 2 returns Property Payments. In this case, Query 1's result set is zero - no data, and it is causing the entire report to be blank. Why would it ignore Query 2??

[raj_aries81]

Hi farmcock,

Did you check if there is a join between these two queries, also I know this is a dumb question just wanted to make sure you have included the data items from QUERY 2 onto the page :)

Regards
Raj

[farmcock]

Thanks for response. No, there is no join between the two. We copied Query 1 to use as Query 2 and simply altered its filter. When I reverse the queries, the report works just fine so it appears to have something to do with the fact that the First Query is empty. If the First query returns data, they both work fine.