RTC Report Footer problem

colinrcolinr Member Posts: 6
edited 2013-03-28 in NAV Three Tier
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

Comments

  • Jatin_PatelJatin_Patel Member Posts: 200
    Have you use Currreport.PREVIEW in your code?
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
  • colinrcolinr Member Posts: 6
    No currreport.preview in code

    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
  • Big_DBig_D Member Posts: 207
    Hi Colin

    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!
    Big D signing off!
Sign In or Register to comment.