Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Print different header values on each page of SSRS report

Posted on by 2,015
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
    Reliable Profile Picture
    Reliable 2,015 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,828 Super User 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,407 Super User 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans