Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Print different header...
Finance | Project Operations, Human Resources, ...
Suggested answer

Print different header values on each page of SSRS report

(1) ShareShare
ReportReport
Posted on by Sangram Shinde 2,094
Hi Techies,
 
We're working on SSRS report development where we need to display data with different header values. 
To elaborate it more, data is like below - 
Data should display 'Department code' wise on each page.
'Dept0001' data should display on page 1
'Dept0002' data should display on page 2.
At body part, by grouping it on 'Department code' page break is working and displaying department-wise on two pages.
Now, at header level we need to display 'Department code' value, which is currently showing Dept0002 on both the pages. We need to display 'Dept0001' at header level on page 1 and 'Dept0002' on page 2.
 
Can anyone guide on this scenario, how can we achieve this. Any response is appreciated.
Thanks in advance !
 
 
 
  • Suggested answer
    Sangram Shinde Profile Picture
    Sangram Shinde 2,094 on at
    Print different header values on each page of SSRS report
    Thank you for the answers Girish and Komi.
    We've used a workaround here - Added one column with visibility property as 'No' and populated department code in each line of tmp table(body part), . 
    Used that textbox value at header level to show it - 
    Example - ReportItems!DepartmentCode.Value (This is a column text box added in body part).
    Since we are populating same value on each page, header value is showing properly (Different on each page) as per the requirement.
     
    Just a note, it's delayed posting the solution.
     
    Regards,
    Sangram
  • Suggested answer
    GirishS Profile Picture
    GirishS 27,825 Moderator on at
    Print different header values on each page of SSRS report
    Hi,
     
    As Komi mentioned you need to add the Department field inside the Body of the report.
    Add Department as Group by field in the tablix and add the required fields below that.
     
    Thanks,
    Girish S.
  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,847 Most Valuable Professional on at
    Print different header values on each page of SSRS report
     
    A suggestion is instead of the header, use the body of the report to display the depart as a heading inside of the grouping and that should display each department of each page.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 185

#2
Martin Dráb Profile Picture

Martin Dráb 147 Most Valuable Professional

#3
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 130 Super User 2025 Season 1

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans