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
i'm struggling with this...any help plz..
Srik
Hi srik
Apply conditional formatting
ur problem will be solved
try it
thanks
siva
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
Try to reverse the condition for your variable. Maybe 0 is not zero after all. It could be null.
tried even that...didn't work...any more suggestion plz...
Srik
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)
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
SOLVED
Quote from: BIsrik on 04 Oct 2005 08:51:10 AM
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