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

Author Topic: Union of queries and  (Read 1995 times)

Virgin

  • Guest
Union of queries and
« 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.