If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Union of queries and

Started by Virgin, 27 Jan 2015 08:13:22 AM

Previous topic - Next topic

Virgin

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.