web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,108
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 !
 
 
 
I have the same question (0)
  • Suggested answer
    Sangram Shinde Profile Picture
    Sangram Shinde 2,108 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 13,032 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 764 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 619 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 603 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans