incorrect values passed to RTC report with .CreateTotals

bertm
Member Posts: 11
hi,
in my classic report, CurrReport.createtotals("Line Amount") is used.
Depending on some conditions, this total or 0 is put into a decimal variable.
This variable is then shown on the report. The correct value is shown.
When i place this value in my RTC report however, the value that is passed to the RTC report is incorrect.
Instead of showing the total, it shows the last value that was suppossed to be added to the total.
for example: there are 3 sales invoices lines, with line amounts: 500,300,700
the total that is shown in the classic report 1500
the total that is shown in the RTC report 700
Is there some problem with the combination of createtotals and RTC reports?
Is there a solution to this?
thanks
in my classic report, CurrReport.createtotals("Line Amount") is used.
Depending on some conditions, this total or 0 is put into a decimal variable.
This variable is then shown on the report. The correct value is shown.
When i place this value in my RTC report however, the value that is passed to the RTC report is incorrect.
Instead of showing the total, it shows the last value that was suppossed to be added to the total.
for example: there are 3 sales invoices lines, with line amounts: 500,300,700
the total that is shown in the classic report 1500
the total that is shown in the RTC report 700
Is there some problem with the combination of createtotals and RTC reports?
Is there a solution to this?
thanks
0
Comments
-
hi
i think you have to concern ISSERVICETIREAshish Gupta
Navision Technical Consultant0 -
Hi,
CREATETOTALS function is not supported by RTC. You should create a sum expression instead to view the value.
RegardsCavit Ilker
Microsoft Dynamics NAV
This posting is provided 'AS IS' with no warranties and confers no rights.0 -
ah, thank you for the reply.
Are there other functions that arent supported by RTC that i should know of?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