ssrs 2008 use 2 iif statements

  • When I want to hide the heading in an SSRS 2008 R2 report, I will also want to set the location of the tablix to 0,0.

    Thus can you tell me or show me in code how to accomplish the following two tasks: 1. User want to hide header values? Place this is a parameter value? 2. In the same iif group of statement(s): a. hide the headers of the report, b. set the location of the tablix to 0,0.

  • The location of a reportitem can't be changed during runtime. But if your header is a part of the tablix you can place your tablix at 0,0 and hide the header based on a reportparameter through your headerrow's "Row Visibility..." property.

    1. Create the reportparameter, check attached images.

    2. In your tablix, select the headerrow, right-click and select "Row Visibility...". Check "Show or hide based on an expression" and use the following expression, IIf(Parameters!HideHeader.Value, true, false).

  • Thank you very much!

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

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