Number of Rows in report

I create a variable that has the following formula

= NumberOfRows() , now this works perfect
but if I put certain conditions on my report which makes a
no data fetch then this varable instead of showing zero shows me
a blank , is there any way of making it show zero instead of blank


DukeofPune (BOB member since 2004-07-15)

I would check the formatting for the cell. It returns zero for me, not blank.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

It shows number when there is data fetch but if there is no data fetch it
just goes blank , I tried to change it to All , standard , number in format
cell option but it does not work


DukeofPune (BOB member since 2004-07-15)

I tried to change it from measure to dimension but it does not help


DukeofPune (BOB member since 2004-07-15)

Duke,

I tried that and it shows me ‘0’ instead of blank.
Do you have sections in your report??

Also, the NumberOfRows function takes in the name of Data Provider; not the column name. It should be

=NumberOfRows(DataProvider())

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)

Sayeed ,

Actually my data provider name is query 1 with Jay_unv
where jay_unv is my universe , when I put this in
NoOfRows function it is giving error I have only 1 data
provider am I doing something wrong


DukeofPune (BOB member since 2004-07-15)

Try this … =NumberOfRows(“Query 1 with Jay_unv”)


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Try using the IsNull function, in order to force a representation different from blank…


Christian Konrads :it: (BOB member since 2004-07-21)

The format I told you uses the NumberOfRows( ) and DataProvider( ) functions.


=NumberOfRows(DataProvider(<COLUMN NAME>)) 

If you provide any column name from your DP to the DataProvider() function; you wont need to type in your DP name.

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)