Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / add grouping to Every ...
Microsoft Dynamics NAV (Archived)

add grouping to Every g/account in last of report

(0) ShareShare
ReportReport
Posted on by ahmed barbary 4,548

Hi guys i make report as title daily receipt report this report consist
of

two tables

G/L Account
G/L Entry
 this report as following
posted date g/l account no  document no   amount
15/03/2012         12                           15              150
15/03/2012         12                           16              200 
15/03/2012         12                           17              200
15/03/2012         13                           18              300
15/03/2012         13                           19              400

i make this report but what i need is to display total for every group in
  footer section or last of report but not after every group .what i need
 to show report as following

 15/03/2012          12       15      150

15/03/2012           12       16      200

15/03/2012           12       17      200


15/03/2012          13       18       300


15/03/2012          13      19        400


12            550


13           700
how i make this as above i make this before by group footer but it
display
after every group but not suitable solution for me.
 so
that  to display every group in last of report i need to add new g/l
account  have group footer to make this task how i make this.
please help me
 thanks

*This post is locked for comments

  • Nick Haman Profile Picture
    Nick Haman on at
    Re: add grouping to Every g/account in last of report

    Ahmed,

    Depending on your build of NAV, the country you are in, and some other factors the support customization would come from a different support group. I see based on where are are located it would not be our specific support group here in the United States, so please email me   nhaman@microsoft.com   and i will send you your partners information as I cannot post that here in the public forum. You will need to go through a partner as that is the only way to get a billable service started with Microsoft since you are not on a Premier Plan. Please email me and I will send you the partner information and you can then contact your partner whom will be able to help you out and contact Microsoft if you wish to pursue a possible billable engagement. Please let me know the build of NAV you are currently running when emailing me as well as if you use the RTC reporting or the Classic Client reporting. Thank you.

    Nick

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add grouping to Every g/account in last of report

    Please i don't know the partner because one person work before me in implementation of navision and he leave the place and i not see him.please if you want to help me tell me steps by details and case that i need as above so that if possible you can give me price

    thanks

  • Nick Haman Profile Picture
    Nick Haman on at
    Re: add grouping to Every g/account in last of report

    You would need to set up a support case so that we could scope the issue and give an estimate. This isn't something we would be able to give a price on without an open case. If interested please open a case with the support department through your partner. Thank you.

    Nick

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add grouping to Every g/account in last of report

    OK  if this report made by billable service how much does it cost

  • Verified answer
    Nick Haman Profile Picture
    Nick Haman on at
    Re: add grouping to Every g/account in last of report

    If you are talking about RDLC reports used by the RTC (Role Tailored Client), then this could be possible, but is not easy. I cannot explain it all here, and actually via our support it would even be a billable service as a customization, but I will try to explain what may work. First, a report in the North America NAV version you could look at that does something similar to this is Report 10040 which is the Aged Accounts Receivable. If you look at the layout, you will see two tables(table1 and Table2) being used, with the one on the bottom(Table1) of the Layout being the one used just for report totals.You will notice that built in Code Functions are needed to get the Totals from the main Table(Table2) used for the data. In the main table(Table2) there is a hidden field you will find which is Textbox72, that stores values into memory in a Code Function called CalcTotalBalance, which those totals are then put into memory and used in the Report Total with another Function called GetTotalBalance. This basically mimics the possibility of a Report Footer as the Totals are in in Table1, in a Footer section using the option to call into the Code Functions found in RDLC. It is extremely hard to explain, so I suggest looking at the Report 10040 and see how it works, which may give you a good idea for your report and how to work it out. If your groups and everything are right, I believe it will work out for you.

    Nick

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans