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
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!