ssrs if - cannot print the requested value

Question

I have the following iif

IIF(LEN(Fields!IDENTITE.Value)=0,"Known manager","Unknown manager")

Yet for some specific case, nothing is appearing (e.g. no known nor unknown)

I checked the results with a sql query and nothing is appearing (the result is below)

I amended my iif to reflect this case

IIF(COUNT(Fields!IDENTITE.Value)=0,"Known manager","Unknown manager")

Yet the same issue is appearing

Any ideas on the why?

Thanks

Update : I tried the countrows as mentionned by @breez and I got this error

Since the sql query result has zero rows, have you tried the "CountRows" function in SSRS? — brz, Apr 06 '16 at 08:12
@breez I tried your advice and I have this error (see update on my question) — Andy K, Apr 06 '16 at 08:18
Is your expression in a table with Row Groups? If so try the `COUNT` expression in an item without grouping, like a standalone text box. — Pete Rennard-Cumming, Apr 06 '16 at 08:58
Hi @PeteRennard-Cumming, I did that (or did I do it correctly?) -_-' — Andy K, Apr 06 '16 at 09:18
Try adding a new Text Box item to the report, with just `=COUNT(Fields!IDENTITE.Value)` as the expression in it. In 2008 R2, this still shows 0 even if the dataset has no rows. Does it do the same in 2012? — Pete Rennard-Cumming, Apr 06 '16 at 09:47
@PeteRennard-Cumming I'm using visual studio 2013. Nothing is appearing , no zero or 1 , just plain `""` — Andy K, Apr 06 '16 at 09:59

score 0 · Accepted Answer · edited May 23 '17 at 12:15

0

One of the possible way to deal with the absence of rows is the following:

Click on the tablix , look for NoRowsMessage option and type the text you want (example: "No known managers")

Next time there are no rows, this message will be displayed

PS: It is only doable for matrix, list and tables not for textbox. For more info, click here

edited May 23 '17 at 12:15

Community

answered Apr 06 '16 at 13:03

Andy K

1 Answers1