web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics AX (Archived) / Two different headers ...
Microsoft Dynamics AX (Archived)

Two different headers in single report

(0) ShareShare
ReportReport
Posted on by Rene Volkmer 326

Hello community,

is there any way how to use two different headers on single SSRS report please? My situation is following. I have SSRS report with header, lines and additional overview lines. I would like to show header A when lines are printed and header B when overview lines are printed. I assume I could use a rectangle for each header and than set visibility on rectangles. But which expression/function should I use for header A/B determination please? Any hint appreciated.

Best regards

RV

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    if you are thinking about using expressions to hide controls based on conditions, it will result in wastage of space and you will get white space.

    A possible solution can be putting everything under body. Keeping no headers for report. Now choose controls which you want to repeat on every page, set them repeat on each page = true. Finally set expressions to hide controls based on expressions.

    AX-SSRS provides no way to save whitespace, in header and footer, in case controls are set visible false, by expressions.

  • Rene Volkmer Profile Picture
    Rene Volkmer 326 on at

    Hello Sohaib,

    thank you for your response. Which expression do you recommend for checking that no more lines are printed and any overview line has been printed in order to hide "header" A and to show "header" B (i.e. placed in a body as you suggested)?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    You can use your Dataset rows to know if there are any records. The SSRS expression to count rows is CountRows("DataSetName")

    Finally you can use IIF condition to show/hide controls.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans