Statement aging did not print on last page bottom of report

aquarious

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.

aquarious

postsaurav

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.

aquarious

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

aquarious

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