SQLTeam.com | Weblogs | Forums

Ssrs 2012 using nested isnothing statements


#1

In an ssrs 2012 report, I need to display various messages depending upon if a field is null , if not null then I need to display another message. I know that I can use a switch statement and check for not (isnothing(field1), but I do not know how to set this up in an expression. Could you show when how to at least get the logic started in ssrs?
Here is what the general logic need to be:
If Language= Spanish
if Spanish date is null display message 1
if Spanish time is null display message 2
if Spanish location is null display message 3
else display good Spanish message
end if
else if language is not ‌Spanish
if date is null display message 4,
if time is null display message 5,
if location is null display message 6,
else display good message.
end if


#2

how are you feeding your SSRS data?

  • from a embedded tsql statement ?
  • a stored procedure?
  • a view ?