Footer at bottom of every invoice page

Business Central/NAV Developers Forum
1

Hi I’m doing some rework on an invoice report. I want to add a footer to BOTTOM OF EVERY invoice page, like in the following: ---- page 1: Header from DataItem 1 Header from DataItem 1 Header from DataItem 1 transheader Details from Dataitem 2 100,00 Details from Dataitem 2 200,00 Details from Dataitem 2 300,00 transfooter Footer on bottom of every page Footer on bottom of every page Footer on bottom of every page ---- page 2: Header from DataItem 1 Header from DataItem 1 Header from DataItem 1 transheader Details from Dataitem 2 400,00 Details from Dataitem 2 500,00 ------- total etc Footer on every page Footer on every page Footer on every page -------- What is the best way to do this ? Inserting a footer section (with ‘PlaceInBottom’ to YES and PrintOnEveryPAge to Yes) will cause ALL footersections (with totals) to go to the bottom. That’s not what I want :frowning: Has anyone any idea on how to do this ? Best regards Josh

2

Hi Josh, have you tried, to create a new DataItem (integer) just for this footer information? Best Regards feri

3

Yep, the first dataitem is based on the integer table. This dataitem (name Footertext) has a footersection with PrintOnEveryPage = yes and PlaceAtBottom = yes. Dataitems: Integer (name Footertext) -Sales Invoice Header (name ) --Integer (name CopyLoop) —Integer (name PageLoop) ----Integer (name DimensionLoop1) ----Sales Invoice Line (name ) -----Integer (name DimensionLoop2) ----Integer (name VATCounter) ----Integer (name Total) ----Integer (name Total2) Invoices that consist of 1 or even more pages are printed correctly. The problem is that after EVERY invoice an empty page is being printed with only the footer of Footertext. How can I solve this ? Best regards Josh

4

Hi Josh, now I got your problem, I think we had a similar problem some time ago [:(]. The output was too long for 1 page, so the system printed a 2nd page for the 1st one (but strange is, that one page was not too long, if there were more pages [Duh!] ). Try to reduce the report, then it should work. Best Regards feri

5

Feri, When I print 1 invoice that spans 2 pages everything prints well. But when I batch-print a couple of invoices then every invoice is followed by a white page with only the footer. What did you exactly do to solve it ? I don’t know what you mean with ‘reducing the report’. Best regards Josh

6

Found it ! There was a NEWPAGE in one of the AfterGetRecords. I removed it and it works well. New problem however is that the Transfooter and Transheaders are not printed anymore…

7

Hi Josh, with “reducing the report” I meant, to shrink each section, and if that is not possible, make the text smaller, or choose another paper size. But as you found that newpage code , this was not the problem [:)]. Hm, no idea about the new footer problem [:(]. Best Regards feri

8

dear Josh

have you got the solution of your problem related to footer you mention above.

if you got the solution please send me that also.

because i m also facing the exactly same problem.

Best Regards

jagdish chandra