Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-05 : 23:42:54
|
| In a SSRS 2012 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-06 : 04:07:22
|
| whats the value you selected for pGrade parameter?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-11-06 : 14:13:09
|
| The value selected for pGrade parameter was "KG". When the value of '01' was selected for pGrade, no error message was generated. The default error message of saying 'no records' were selected appeared on the report.Thanks for looking into this error message! |
|
|
|
|
|
|
The query returned no rows. The expression therefo