sql server reporting services: Display N/A Something When Data Does Not Exist -- sql server reporting services

Display N/A Something When Data Does Not Exist

gMaster
1/31/2005 3:25:02 PM

sql server reporting services: Hi I have a dataset with 2 columns Col1 is a list of dates and col2 is a list
of Values
On my report I put a filter on a list filtering out the dates with
expressions. Such as = (colDate.value = myDate)

But some time myDate does not exist in the dataset, so the after the filter
the list has no results.

What i want to achieve in this case is to display an N/A. i tried something
like this in the textbox contorl inside the list
=IIF(IsNothing(col2Value),"N/A",col2Value) but that does not work.

RE: Display N/A Something When Data Does Not Exist

chanley54
2/1/2005 4:13:02 AM

Hi,

Why not try something within your stored procedure

Select Col1(ISNULL, 'N/A') FROM TABLE

[quoted text, click to view]

RE: Display N/A Something When Data Does Not Exist

isamu
2/1/2005 8:23:05 AM

Is this in an actual "list" control? There is a property in the properties
panel, called "NoRows" .. you simply type the text you want to display when
there are no rows in the list. Hope that fixes your problem.

[quoted text, click to view]

RE: Display N/A Something When Data Does Not Exist

gMaster
2/1/2005 7:39:02 PM

thanks that worked.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.