Hide empty

building reports webintelligence
1

Hello All,

In report I have empty rows. I have used variable in those row but the variable doesnot have values for some customer. I need to hide empty row in report.

Thanks
SH

SH3230 (BOB member since 2010-10-25)

2

Hi,
In Properties of that block under Display, un check option" Show rows With empty measure Values"

This will solve your issue.
You can also try using filter as “[Measure] is not null”

Cheers

bo_user123 :uk: (BOB member since 2010-09-22)

3

Hello,

I have already tried that. Some block are hiding some doesnot.

Thanks

SH3230 (BOB member since 2010-10-25)

4

Hello All,

My requirements is to hide a block when there is no data.I have used formula in the block.I tried to used Not Null option and un check option" Show rows With empty measure Values.It is not working.

Any idea.

Thanks for your help.

SH

SH3230 (BOB member since 2010-10-25)

5

Sounds more like you should look at filtering out those rows based on your variables result.

dfoster99 :uk: (BOB member since 2010-11-05)

6

It it a crosstab report? (better attach a snapshot of the report…)

sati_sunil (BOB member since 2010-09-16)

7

Had the same issue. Hiding rows with empty values doesn’t seem to work when the measure is a variable derived from two measures from different queries. e.g. VariableA = Measure1 / Measure2. You are likely to have the merged dimension, which unions the dimensions from the merged dimensions AIUI, as the row heading.
If Measure1 is null or Measure2 is null then the cell in the xtab will be “empty”
Rather than using the merged dimension, for the row headings, I used the dimension from the query that provided Measure2. This restricted the xtab to rows where Measure2 was not null and I now have no blank rows. :slight_smile:

matt.birchall (BOB member since 2011-06-29)

8

As per you question statement -
It means two things

  1. One you want to hide rows or cells in a report where your specified measure is null
  2. You have multiple blocks in report and you want to hide blocks in a report where there are null values

For 2 - Deselect show when empty after selecting that block and deselect show measures with empty values options

For 1-
A) If this is from single query than hide measure where null option and first check with isnull(measure) that value being displayed is 1 or not. then where isnull () is 1 hide the rows
B) If you are taking merge dimension than just bring the merge dimension from the query for which you want to display measures like if you are merging column Accounnumber from query A and Query B and you want to show all measure for query A than put accountnumber from A in the query and hide it.

If it doesnot solve please elaborate the issue.

maverick_bocp (BOB member since 2012-01-05)