Post reply

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

  • November 5, 2013 at 9:40 pm

    #395779

    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?

  • November 7, 2013 at 10:14 am

    #1664855

    iif(Not IsNothing((Parameters!pGrade.Value) AndAlso (Parameters!pGrade.Value = "KG" OR Parameters!pGrade.Value = "01"), False, True)

  • November 7, 2013 at 12:27 pm

    #1664896

    Thanks!

  • November 8, 2013 at 1:37 am

    #1665014

    😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply