Monday, October 25, 2010

WEBI XI: Display data only if the number of rows is less than

If you want to display the report data only when a specific rowcount is achieved you can do it using the following procedure:



1) Create a variable (replace 50000 with your number of rows). If you have more than one DP just add their rowcount.
Name: DP01_ROWCOUNT
Formula: =If NumberOfRows([Query 1]) > 50000 Then 1 Else 0



2) Create a global filter on the aforementioned variable:
DP01_ROWCOUNT Not Equal to 1


3) Uncheck option "Show When Empty" on all blocks

No comments:

Post a Comment