AX 2012 - view row headers on all the pages of a SSRS report

Today we will learn on how to view row headers on all pages of a AX 2012 SSRS report

If you want to view row header on all columns:
  • Select tablix and Click advance after.


Here we have two rows above our data. You can see two static members under row group above details.

That means we have to change properties of both static members.

Properties:
  • FixedData = true
  • KeepWithGroup = above
  • RepeatOnNewPage = true

If you want to hide first row containing fields from date and to date.
For the first static member, change these properties.
Properties:
  • FixedData = true
  • KeepWithGroup = None
  • RepeatOnNewPage = true


Deploy it and add to AOT.

View the Output.

No comments:

Post a Comment