Hiding Rows based on row count

building reports desktopintelligence
1

Hi,

I need to hide some rows in my report … having a tough time…:hb:

basically in my report …I use rowcount on empid.

and

now I need to hide the rows with rowcount >1 and the row with max rowcount value.

For example:

Col1 Col2 Col3 Empid Rowcount ColumnNo

A A1 A2 20 1 1

A A2 – 20 2 2

B B2 B3 10 1 3

C C2 C3 30 1 4

C C2 C4 30 2 5

C C5 – 30 3 6

Now in this I need to Hide rows 2 & 6.

Please let me know if you have any ideas

Thanks In Advance…

teenas_22 (BOB member since 2008-02-25)

2

Did you try to define the filter for this?

BO_Stuffed (BOB member since 2008-03-29)

3

That is a measure… a filter cannot be applied on a measure…

Thanks.

teenas_22 (BOB member since 2008-02-25)

4

I’m confused, Teena. Filters can be applied to measures. Did you try it out?

Jansi :india: (BOB member since 2008-05-12)

5

This a Report variable and I am not able to apply filter on this variable…

also for requirement I have I Dont think I can use filter’s

Thanks.

teenas_22 (BOB member since 2008-02-25)

6

You can apply a filter to report variable, unless you have any aggregate function in its code.

If you can share the code you use, probably someone can give you at least a better alternative to achieve the same.

Jansi :india: (BOB member since 2008-05-12)

7

Ok got you … but

this variable is defined as

Runningcount(empid:empid)…

thatz the reason why I am not able to apply a filter

teenas_22 (BOB member since 2008-02-25)