Is there a way to not repeat a Row Header after the first page? I have a report where in the first page I get last month balance for a specific account which will be visible only on the first page. I need to hide that row in the following pages.
Any help will be appriciated.
*This post is locked for comments
Create two groups to display the first as you are doing now but only with two headers and in the second group display the third header and display it only on the first page.
not a programmer here, but why do you consider this a header?
Isn't it just the first row of the body of the report?
As the first row, it would get printed once, under the true header rows and would only print on the first page.
You're all scaring me if this is such a huge issue in creating NAV reports...
I have group the data in the Tablix, the thing is that I need to be able to display the first two group headers in all pages but the 3rd one only on time in my first page.
Try to create a groups and display the group header only on the first page.
Yes Suresh, they are in the same Tablix. The 3rd and last row displays the initial balance of any given account.
Are all the header rows are on the same tablix ? if not you can use the Repeat Header Rows on each page on tablix properties, uncheck that so that it will repeat only the first page.
If not you have to control that programatically by setting a variable to true and using that as visibility expression.
Thanks for the reply Jonathan, the Tablix is inside the body of the report therefore Global variable are not accessible.
set the visibility of the row to =(Globals!PageNumber<>1).
add a new row under this row, copy the same cell values to the new row. set the show rowheader value to false, set the visibility of the row to the opposite. then on first page row 1 is shown, other pages is row 2 shown (without row header).
A little more information: My Report has 3 headers,
The one I'm trying to hide is the last header (the one inside the red rectangle) where I'm showing last month balance.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (