How to show "Page Blank" on report when Query retu

building reports webintelligence
1

XI 3.1

I have a Document with 2 Report tabs
I have 1 Query
Report 1 always has data - there is always an answer set.

Report 2 can sometimes be blank because it has a Report Filter that can result in a blank report.

I want to place a message on Report 2 when it comes up blank. Problem is - my Query always returns data - only my report filter results in a blank report by filtering out the data. Can anyone help?

I’ve tried Number of Rows, but that only works for the Query and i only have one Query. I don’t want to use 2 queries.

Thanks.

farmcock (BOB member since 2008-01-15)

2

Try this.

  1. Add a Cell to your Report and enter in the Cell what you want it to say when the table is blank. Like “No data meets the criteria for this report”

  2. Create a variable that checks to see if any data meets your filter criteria such as:


[Check Filter]= Max(if([Revenue] ForEach([City])>30000;1;0))

The context is important in this variable because you will be applying it to a cell that has no context.

  1. Create an Alerter that checks to see if your [Check Filter] variable is equal to 1 so your alerter equation would be:

[Check Filter]=1

Click on the format button of your alerter and set the formula to =""

  1. Apply the alerter to the cell from step one. This will hide the statement if there is data returned in your table but show the statement if there is not data in the table.

jbarnes794 :us: (BOB member since 2008-06-13)

3

Thanks.

farmcock (BOB member since 2008-01-15)