grouping data in integer data item in last of report

ahmedba
Member Posts: 424
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 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 what i need is to add integer data item in last of report this data item make grouping to evey group in report how i make this
and what i write of code in data item integer .
please help me
thanks
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 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 what i need is to add integer data item in last of report this data item make grouping to evey group in report how i make this
and what i write of code in data item integer .
please help me
thanks
0
Comments
-
Try using the "date" virtual dataitem. With the right setting you'l be able to get a record per day ( i am assuming that is what you want ). You'l probably will have to add the same calculations and/or code as you had for the first sections of your report.
Another way would be to use a temporary table for totalling and add your numbers to that during the first pass, then use an integer dataitem to display what s in the tempraryo table afterwards.
btw, your example data seems to be wrong, you are showing a total for 13, but there are no lines with 13 in your example.0 -
Do you always have to see all the Line Details?
Perhaps you can add a "Detail" or "Summary" option to the Options tab of the report.
If they select Summary you only see the Group Totals by controlling what is shown.
If the user wants to see all the entries that created the total they can hit detail.
IE/ See Aging Reports.
PrintDetail type Boolean
OnPreSection()
CurrReport.SHOWOUTPUT := PrintDetail;0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions