How to delete/hide empty rows?

building reports desktopintelligence
1

Hello,

I’m quite new at BO, but I have a problem that seems quite unsolvable (to me)

Here’s the description.

Every day I import new data through Excel as data provider.
This data contains a lot of informations, but I want to exclude only the informations that have a value, everything else I want to hide.

The thing works when I use filter and select non-empty cells, but I can’t use it every day because of huge amount of the data…

Is there a way how to make this simple?
I tried with function

Not IsNull()

but it throws back only value “1,00”

I attached a picture for better visualisation.
prtscr.JPG

BHawk (BOB member since 2009-01-16)

2

Hi,

Create new variable with formula :

=If(IsNull(<TRAN_DATE>)) Then 0 Else 1

Apply filter on that variable with value result “1”

pravin_gaikwad :india: (BOB member since 2010-03-27)

3

Actually I did this in Access (I export the data from access to excell) and then I filtered the data in BO.

Thanks

BHawk (BOB member since 2009-01-16)