Hi,
I have 1st query in the report that get customer information such as address, name with certain order# (info needed in the page header).
Then 2nd query in the report to select the orders from the 1st query that contain specific items (content in the report). I only want to print out reports in the 2nd query.
Now I got all the reports selected from the 1st query with the customer info/order# in the page header, some of them have no data because the specific items (in the 2nd query)is not in the order.
We use 2 queries for the purpose of performance. Also the items specified are dynamic. Is someone know how to delete the pages with no data?
P.S. Is anyone know if there is any more active forum for Actuate report (older version, not BIRT)
Thanks.
I have 1st query in the report that get customer information such as address, name with certain order# (info needed in the page header).
Then 2nd query in the report to select the orders from the 1st query that contain specific items (content in the report). I only want to print out reports in the 2nd query.
Now I got all the reports selected from the 1st query with the customer info/order# in the page header, some of them have no data because the specific items (in the 2nd query)is not in the order.
We use 2 queries for the purpose of performance. Also the items specified are dynamic. Is someone know how to delete the pages with no data?
P.S. Is anyone know if there is any more active forum for Actuate report (older version, not BIRT)
Thanks.