Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problem in Detail Trail Bal RTC Report
shettarvikas
Member Posts: 106
Hi,
In Detail Trail Balance report, under the G/L Entry dataitem, I have linked "Posted Narration" to print Narration for each entry. Then in RDLC, I have created a new group, and assigned all the gl entry fields (that was printing in body) to this new group. Under this group, I have created a body row and assigned the narration fields.
When I preview the report, it prints fine. But the summation of the Debit/Credit Amount is printing wrong. Wrong in sense, that, if an entry has more than 1 line of narration, it sums the same amount that many times.
Then I tried using a variable to sum the amount in OnAfterGetRecord of GL Entry and display the same in the RDLC group(2) footer, but the value is not printing, its blank. I tried using "Last", but still it is printing blank.
Please let me know, how can I resolve this issue. Only the requirement is to print narration for entries in Detail Trail Balance.
Thanks & Regards,
Vikas
In Detail Trail Balance report, under the G/L Entry dataitem, I have linked "Posted Narration" to print Narration for each entry. Then in RDLC, I have created a new group, and assigned all the gl entry fields (that was printing in body) to this new group. Under this group, I have created a body row and assigned the narration fields.
When I preview the report, it prints fine. But the summation of the Debit/Credit Amount is printing wrong. Wrong in sense, that, if an entry has more than 1 line of narration, it sums the same amount that many times.
Then I tried using a variable to sum the amount in OnAfterGetRecord of GL Entry and display the same in the RDLC group(2) footer, but the value is not printing, its blank. I tried using "Last", but still it is printing blank.
Please let me know, how can I resolve this issue. Only the requirement is to print narration for entries in Detail Trail Balance.
Thanks & Regards,
Vikas
0