grouping and calculating (tataling) Excel buffer varible

mohasin
Member Posts: 16
I have excel buffer variable,i want to group common entries in it and calculate total for the each gruop
please help me
please help me
0
Comments
-
In the US database, you can look at the Aged Accounts Receivables report. It has example on how to do this.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Unable to understand that report,
please tell me in-terms of explaination with just few lines.please....0 -
Figuring out how something works is one of the most important skills that you need as a developer.
Open classic client, and run the report, making sure you check the 'print to excel' checkbox. See if you can set a filter so that it only prints a few lines, say on a customer that only has a couple of outstanding invoices.
Turn on the debugger, and run the report again. Step through it and see what happens. Figure out how it works. You know what's going to happen because you've run it without the debugger, so you can match what is going on in the code with what you know is going to happen with the report.
If you don't get it the first time, do it again. For something like this I would expect you to spend at least a whole day just to get to a point where you can recognize what code does what task. It will also give you a good idea of the flow of a report object.
Good luck0 -
mohasin wrote:Unable to understand that report,
please tell me in-terms of explaination with just few lines.please....
If you're not able to figure it out with the coding sample already provided, you should seek a senior person to help you.
Asking someone on the forum to teach you how to program is not going to work.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Hi Experts,
But In My case problem is that i done the grouping through group footer and i can export the data of Header , Data and Footer easily
trough Add column function of excel buffer table but when i tried to export data of group footer it doesn't work please any one help me
Regards,
Rishi Chourey0
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