Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 r2 error:The Hidden expression for the tablix 'Tablix3' contains an error: The query returned no rows. The expression therefor evaluates to null Expand / Collapse
Author
Message
Posted Tuesday, November 5, 2013 9:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:07 PM
Points: 375, Visits: 441
In a SSRS 2008 r2 existing report, I am getting the following error message when the value selected by the user should be:
Parameters!pGrade.Value = "KG".

"The Hidden expression for the tablix 'Tablix3' contains an error: The query returned no rows. The expression therefor evaluates to null."

The error message could occur on one of the iif statement(s):

1. hidden property on Tablix3 =iif(Parameters!pGrade.Value = "KG" OR Parameters!pGrade.Value = "01", False, True)

2. expression on one of the group header rows =iif(Parameters!Team.Value = "ALL","ALL", Parameters!Team.Value)

Can you tell me which iif statement could be causing the problem and what code should I use to keep the error message from occuring?
Post #1511711
Posted Thursday, November 7, 2013 10:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 1:17 AM
Points: 44, Visits: 210
iif(Not IsNothing((Parameters!pGrade.Value) AndAlso (Parameters!pGrade.Value = "KG" OR Parameters!pGrade.Value = "01"), False, True)
Post #1512363
Posted Thursday, November 7, 2013 12:27 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:07 PM
Points: 375, Visits: 441
Thanks!
Post #1512414
Posted Friday, November 8, 2013 1:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 1:17 AM
Points: 44, Visits: 210
Post #1512557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse