web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Continued in groupheader and page number reset in SSRS

(0) ShareShare
ReportReport
Posted on by 55

Here is a challenging situation that we face with SSRS reports.

We have two tablix groups placed inside a list. The list gets printed for every customer. One group inside specifies all the transactions related to the customer and the other specifies all the address from the customer.

1. What the client want's is when the group extends beyond the first page the group header must be like "..Continued customer transactions" and so.

2. When ever the customer id changes the page number must be reset to 1.

So far i have explored various methods. I see that SSRS 2008 R2 supports a Page reset option at group level but that is not available for AX SSRS.

I'm wondering if anybody has already faced a situation similar to this. Any help is much appreciated.

Thanks

sudheer

*This post is locked for comments

I have the same question (0)
  • venkatesh vadlamani Profile Picture
    3,180 on at

    Hi ,

    try this

    Create another text box inside the group with running value of the row count under current group scope.

    on the page header get the first value of text box and convert to int , If this is greater than zero show the text box in page header else hide. In expression you place your hard coded message

    Hope this might work

    regards

    Venkatesh

  • Community Member Profile Picture
    on at

    Hi, Im new to AX and i also facing same issue.

    Based of your suggestion, how to create the running value under group scope? Can you explain more briefly?

    Thanks.

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans