Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

SSRS Dynamics Header Title Based on Different Tablix

Posted on by 1,204

Hi,

I have a report with three tablixes in the report body, each populated from different data sets. Each tablix is separated by page break.

This report is quiet complicated so I have to use different data sets to separate the data.

In the report header, I want to change the title dynamically based on which tablix is currently populating the body. 

I tried using Globals!PageName but got "Globals!PageName is invalid. InvalidProperty" error when deploying my report.

Why is it I cannot use this Globals!PageName? Is it not supported in AX 2012 somehow?

Are there any alternative way(s) to achieve this?

Thank You.

  • Suggested answer
    Ehab_altammam Profile Picture
    Ehab_altammam 150 on at
    RE: SSRS Dynamics Header Title Based on Different Tablix

    Hi HAIRRul,

    you can use a report item ....

    add a hidden text box , fill it with different value for each case  and use Reportitems!(textBoxname).value .. so you can use iif to switch between your returen values

    docs.microsoft.com/.../built-in-collections-reportitems-collection-references-report-builder

  • Samppa Profile Picture
    Samppa 23 on at
    RE: SSRS Dynamics Header Title Based on Different Tablix

    Have you set pagename property for those tablixes ?

    Maybe this will help you:

    social.msdn.microsoft.com/.../how-to-add-the-page-name-in-the-report-body

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans