Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 270 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
RTC Report Footer problem
colinr
Member Posts: 6
I have added 3 totals to my Standard Sales Invoice report
I have added them as hidden fields on the Body
They sum up correctly via the SetData/Getdata function
eg. + Cstr(Sum(Fields!NetPrice.Value)) + Chr(177)...etc..
When I do a report Preview they display correctly, and if i print from the preview they print correctly
If I run the report and print WITHOUT the preview, or Post and Print then the fields dont display, they are just blank, not even 0.00
Has anyone seen this before, or can anyone help?
Thanks
Col
I have added them as hidden fields on the Body
They sum up correctly via the SetData/Getdata function
eg. + Cstr(Sum(Fields!NetPrice.Value)) + Chr(177)...etc..
When I do a report Preview they display correctly, and if i print from the preview they print correctly
If I run the report and print WITHOUT the preview, or Post and Print then the fields dont display, they are just blank, not even 0.00
Has anyone seen this before, or can anyone help?
Thanks
Col
0
Comments
Microsoft Dynamics NAV Consultant
Jatin's Blog
I have got around the issue by calculating my line data in the header dataitem, using a new rec variable, and passing the 3 totals from there, then calling them directly from the footer
Not ideal but it works
One problem I have found today (quite a major one!) is that if you print more than 1 invoice the footers all show the data from the first one!!
Doh!!
Back to the drawing board!