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