Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / add new gl/entry have ...
Microsoft Dynamics NAV (Archived)

add new gl/entry have group footer proplem

(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

12/03/2012         12                           15              150

12/03/2012         12                           16              200

12/03/2012        12                            17              200

12/03/2012        13                            18              300

12/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
:

12/03/2012 12 15 150

12/03/2012 12 16 200

12/03/2012 12 17 200

12/03/2012 13 18 300

12/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 entry  have group footer to make this task how i make this.
please help me

thanks

*This post is locked for comments

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add new gl/entry have group footer proplem

    Please guys can any one help me in solving this proplem

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add new gl/entry have group footer proplem

    Can any one help me in this task by credit please help me

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add new gl/entry have group footer proplem

    can any one told me the second data item i will added is g/l entry or g/l account

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add new gl/entry have group footer proplem

    Hi guys i added  third data item as following:

    g/l account              <g/l account>         first data item

      g/l entry                 <g/l entry>              second data item

    g/l account            <g/l account 2>     third data item

    third data item without indentation second data item have indentation with first data item (g/l account)

    i grouping first g/l account data item by No

    and copy filters and every thing in third data item G/laccount but amount display as 0 values to all No

    how i make grouping in third data item g/laccount

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add new gl/entry have group footer proplem

    please tony if you can help me in this question as above please help me thanks

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add new gl/entry have group footer proplem

    can you explain to me the second way  i make my report as  the second way

    data item                name

    g/l account              <g/l account>    first data item

    g/l entry                   <g/l entry>         second data item

    g/l entry                 <g/l entry2>        third data item

    and then put the second data item as body to represent all records transaction:

    document no  glaccountno  posted date  amount

    then i put third data item as group footer

    g/laccountno                         amount

    then i make GroupTotalFields to second(g/l entry) and third data item(<g/l entry2> )  to g/laccount no

    then i put in predataitem to first data item and second

    currreport.create total(gl/entry.amount);

    put no result

    it display all records in report without any grouping in last of report

    to summarize what i say the report take this shape:

    g/laccount header1

    g/laccount header2

    document no  glaccountno  posted date  amount

    g/l entry body1

    document no  glaccountno  posted date  amount

    g/l entry 2 group footer

    glaccountno     amount

    now how i display grouping in last of report still proplem

    i m sorry to ask you again but please help me

    thanks

  • Tony Hemy Profile Picture
    Tony Hemy on at
    Re: add new gl/entry have group footer proplem

    You can do this one of a number of ways.

    1. Create an Array/Temporary Table, populate that as your cycle through the record, then in your report create a new "Integer" dataitem and re-display your totals.

    2. Have 2 dataitems, have one cycle through all the record, and have the other only show the GroupFootersection, and ensure that the Grouping is set to "G/L Account No."

    t

  • Suggested answer
    ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: add new gl/entry have group footer proplem

    yes that what i need to make but i cannot make

  • Tony Hemy Profile Picture
    Tony Hemy on at
    Re: add new gl/entry have group footer proplem

    Hey Ahmed,

    I am still trying to figure out what you want to do here.

    Are you saying you want the report to loop through all the records in a particular sort sequence; in this case "G/L Account No."

    And then at the end of the report you want to see a sub total for each G/L Account?

    t

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