COGNOiSe.com - The IBM Cognos Community

IBM Cognos Express => IBM Cognos Express => Topic started by: Virgin on 27 Jan 2015 08:13:22 AM

Title: Union of queries and
Post by: Virgin on 27 Jan 2015 08:13:22 AM
Hello everybody,

I have a report with crosstab.

I have a query with the data of 2 different companies : A and B, and i want if there is no data for the company B to show a object box ("No data for B").

I tried with variable of rendering, but it's not efficient.

So I tried with union: first query with the data of company A and the second query with the data of company B.

But it's already unefficient.

Thanks you for your help.