Options

Statement aging did not print on last page bottom of report

aquariousaquarious Member Posts: 32
edited 2013-09-17 in NAV Three Tier
Hi All,

I need help, this report originally from Report ID 17110 (Australia/New Zealand Nav 2013 ver). I have modified and position the aging band to the bottom of the report (Footer) and it is working. However for record that have more then 1 page the second page and following page bottom of report will print blank result at the footer.

I wanted to print this report in the bottom of last page for each record.

Did anyone have any experience on this and could advice me for solution?

Thank you.

Comments

  • Options
    aquariousaquarious Member Posts: 32
    img1_zps36c20058.jpg

    img2_zps32a5641e.jpg
  • Options
    postsauravpostsaurav Member Posts: 708
    HI aquarious,

    Just check the Logic in Report 1401 Check Printing.

    The Check always get printed in last page after all details get printed.

    I hope you will be able to find the Logic that you are looking for there.

    Let me know if you have any issues.

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • Options
    aquariousaquarious Member Posts: 32
    Hi postsaurav,

    Thank you for your feedback, I have try using Report Check Report ID 1401, the last record did not appeared to be correct value and the value is picking up from the second last record. If i filter by one customer no. record (Filter by Customer No. X) there are no record coming out at all at the footer.

    I have not find solution yet. I hope someone can share some idea.

    Thank you
  • Options
    aquariousaquarious Member Posts: 32
    I have resolved this. I have follow the Report 1401 Check as example but for aging band text boxes in the footer of the statement must not position inside the rectangle.

    The formula "iif(CBool(ReportItems!IsLastRec.Value),False,True)" i have set it to every aging band text boxes under Text box Property -> Visibility

    Thank you postsaurav for feedback
Sign In or Register to comment.