Print Page - Query 1 is empty, so it is ignoring Query 2

Title: Query 1 is empty, so it is ignoring Query 2
Post by: farmcock on 17 Jun 2016 02:33:14 PM

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??

Title: Re: Query 1 is empty, so it is ignoring Query 2
Post by: raj_aries81 on 20 Jun 2016 02:00:15 AM

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

Title: Re: Query 1 is empty, so it is ignoring Query 2
Post by: farmcock on 20 Jun 2016 03:03:39 PM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: farmcock on 17 Jun 2016 02:33:14 PM