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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Customer account statement (CustAccountStatementExt) - change in output

(0) ShareShare
ReportReport
Posted on by 86

Hi everyone,

I have a requirement to customise the 'Customer account statement' report (CustAccountStatementExt) so that when it is launched for more than one customer, instead of creating multiple reports per customer, it will print out 1 report with page breaks for each customer.

A simple example would be that if i run this report for 2 customers, instead of Ax producing 2 reports for each customer that there would be 1 report (one window) with each customer starting on a new page.

I would really appreciate any help, ideas or insight on how to do this. I have been looking at the class, CustAccountStatementExtController and the method 'runPrintMgmt' as this seems key to the process where a report is generated for each customer but I'm not sure where to start at the moment. Would it be possible to customise the design in Visual studio so that the current design is contained within a tablix (or something similar) and this is repeated (grouped) with a page break for each customer?

Thanks in advance and kind regards

Stephen

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Girija Shankar Beuria Profile Picture
    690 on at

    I cannot recall the full report design but giving you suggestion. the details may vary a bit though.

    You would start with the controller. The controller would be passing each customer id to RDP and generating the report , then pass the 2nd one and generate the report. In controller, pass all the customer ids as a single string (cust1, cust2). In RDP, for each customer id run the logic and fill the table with all customer data.

    In design you might have to create a group on existing tablix (based on customer id). Mention page breaks for group.

    That should do the trick. Hope this gives a starting point.

    - Girija

  • Stephen King Profile Picture
    86 on at

    Hi Girija

    I really appreciate your reply - thanks! Your suggestion sounds good and i will give it a try now. If you can think of any examples where this or something similar has been done before it would also help a lot.

    Thanks again

    Stephen

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dekion Profile Picture

dekion 4

#2
Virginia99 Profile Picture

Virginia99 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans