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?