[Solved] Display the number of records read

[BIsrik]

I want to display the number of records read in a report. using row number..works fine when the report outputs some data. When there is no data shown in the report the row number doesnot show zero...

Suggest me how to get this...

Srik

[BIsrik]

i'm struggling with this...any help plz..

Srik

[asivaram_krishna]

Hi srik

Apply conditional formatting
ur problem will be solved
try it

thanks
siva

[BIsrik]

i tried even that...it works well when some data are read...if there is no data read then it doesn't outputs the ' number of records read as zero. '

Srik

[Darek]

Try to reverse the condition for your variable. Maybe 0 is not zero after all. It could be null.

[BIsrik]

tried even that...didn't work...any more suggestion plz...

Srik

[mallika]

instead of using the function rowcount(), create a calculation column, set the value of the column to 'null' if all the other columns are null by doing something like this:

1.if([column_1] is null and [column_2] is null and [column_3] is null)then (null) else (1)

[BIsrik]

Got it..

first added a data item as count(qty) and used this data item in conditional formatting. Got the result..

Thanks for the help guys...

Srik

[BIsrik]

SOLVED

[sir_jeroen]

SOLVED

Plz take a look a board rule number 6. Here you find the proper way to close a topic. But tnx anyway for your last post