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) / How can I set the each...
Microsoft Dynamics AX (Archived)

How can I set the each page total in Visual Studio 2010

(0) ShareShare
ReportReport
Posted on by Community Member

I am doing the report in AX2012 and Visual Studio 2010. There is a header and footer. The content (body) has ten (10) records. Therefore, the header and the footer will show in each page and the body only show a record in each page as well.

In addition, I WOULD LIKE TO HAVE A TOTAL IN EACH PAGE FOR EACH ITEM, I DON'T WANT TO HAVE A TOTAL FOR ALL ITEMS AT THE END OF ALL PAGES. So what can I do in the visual studio 2010 to set the page total. Please give me some advise.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Zain Bokhari Profile Picture
    Zain Bokhari 3,208 Moderator on at

    Hi satoyuichi,

    You can have a group expression for number of record on a page. Lets say you can show 10 maximum records on a page, and add a totals row for that group based on this row count limit. That can show totals on each page.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

          Please look into this link,

          community.dynamics.com/.../234825

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

       Please check this also,

       community.dynamics.com/.../234709

  • Community Member Profile Picture
    Community Member on at

    In the "General" page of "Group Expression".

    I input "=CountRows() < 4" in the group expression.

    The "Deploy Solution" in the visual studio and the "Deploy Element" were successful, but it cannot generated the report in AX2012. Error "Error while setting server report parameters. Error message: The item '/DynamicsAX/THK_WMSShipmentInvoice.HaitiFactoryInvoice' cannot be found. (rsItemNotFound)" occurred.

    If I delete this group expression. The report can RUN ALL records in a page which is not my needs.

    So what should I write in the group expression. Please give me some advise, thank you.

  • Community Member Profile Picture
    Community Member on at

    Hi Zain,

    In the "General" page of "Group Expression".

    I input "=CountRows() < 4" in the group expression.

    The "Deploy Solution" in the visual studio and the "Deploy Element" were successful, but it cannot generated the report in AX2012. Error "Error while setting server report parameters. Error message: The item '/DynamicsAX/THK_WMSShipmentInvoice.HaitiFactoryInvoice' cannot be found. (rsItemNotFound)" occurred.

    If I delete this group expression. The report can RUN ALL records in a page which is not my needs.

    So what should I write in the group expression. Please give me some advise, thank you.

  • Suggested answer
    Zain Bokhari Profile Picture
    Zain Bokhari 3,208 Moderator on at

    Hello satoyuichi,

    My appologies if my first reply gave you the impression that we can use aggregate functions in our grouping expressions. We Can Not!!

    You would have to find a work around for it. Lucky for you I have it for you, please change your group expression to "Floor((RowNumber(nothing)-1)/4)"


    Cheers!

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Zain,

    Thanks for you answer. I use "CEILING(RowNumber(Nothing)/4)" in a new group and get the result. Thank you very much, Zain.

    Regards,

    satoyuichi

  • Zain Bokhari Profile Picture
    Zain Bokhari 3,208 Moderator on at

    Please mark the helpful answers as verified. 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…

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