Last post Sep 09, 2015 06:01 PM by jesalynolson
Sep 09, 2015 03:32 PM|Aju Sebastian|LINK
I have an SSRS Report, 1 Parent and one sub report. I have a header in parent reports with a text box in it, is there a way so that I can make my report in the following way.
1. The Header text box should not be there for first page for a sub report.
2. Header Test xob should be available for all other pages.
I have 182 sub reports to be generated in the master report, so I need every first page of sub report to exclude the Text Box. Is there an expression in your mind that will help me.?
Sep 09, 2015 06:01 PM|jesalynolson|LINK
You can create a function under Report -> Report Properties -> Code. You can then use this as a variable. So for the visibility section in Text Box Properties, you will set the Show or hide based on an expression to =iif(Code.PageNumber()=1,true,false).
It works for any text box in the report.
Function PageNumber() As String