Page Suppression

[ourhari1]

I currently work on a multi-page report. The last page has two list components in it. My requirement is: when at least one list has the data, the page should be rendered. If both lists are empty, the page should not be rendered.

Both lists use different query subjects.

For a similar situation, with a single list, i did the following to arrive the solution.
1. Created a duplicate QS.
2. Set the QS to the page object.
3. Create a conditional variable to check a number field value > 0
4. Use this as the render variable in tree page object

I tried a similar approach here; by creating a union QS using the two base QS
However, I get an error about optimization mode=allRows (at present I don't have the exact error message on hand.  I'll post soon).

I request if any one have solution for this issue; or do we have ant other better solution?

Your Help is much appreciated.

[ourhari1]

Here is the error detail:

CCLAssertError:0:Fatal: CCL_ASSERT_NAMED(m_bAllRowsOptimization == false, "The master dataset cannot be re-used for a second iterator if AllRows optimization was applied when the query was executed.");

[mrcool]

Hi,

Select the list and change "Render Page When Empty" property to No. Hope helps.

Cheers,
MC