Navision RTC Report Footer on End of Last Page

postsaurav

Hi all,

I tired many things but unable to fulfill my requirement.

Here is what i want -

1) Report Footer Section in the Bottom/End of Last Page Only.

Already tried this but its not working, as i want the feature when user tries to print report for multiple Records.

=IIF(Globals!PageNumber = Globals!TotalPages, False, True)

So exactly i need is to find the last page of the group to print the footer.

Does anyone know how to do it?

clausl

I would argue that this cannot be done in RDLC 2008. We need RDLC 2010 so we can reset page numbers per group see this feature explained here:
http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx. Since NAV 2013 only supports RDLC 2008 this will be hard to solve.

On the other hand it looks like the developer of report "1401 - Check" actually tried to solve this limitation in RDLC 2008.
In report 1401 the rectangle in the footer is only shown when the last row is reached in the Group in the Body.
The Visibility value for the Rectangle is: "=iif(CBool(ReportItems!IsLastRec.Value),False,True)"
And the value of "IsLastRec" in the Table in the Body is "=iif(CInt(CountRows("Table1_Group1")) = CInt(RowNumber("Table1_Group1")),True,False)"

Maybe you could try and see if this solves your issue.

/Claus Lundstrøm

postsaurav

Hi Claus,

Thanks for the input.

That was great but i still have an issue..

My footer size is somewhere around 12 lines and with this it prints only on last page, that great.

But it keeps 12 Blank lines in every page before the last page.

Is there any way to remove that space from the pages where footer dosen't get printed?

deV.ch

No that is not possible.

The size of the Header & Footer Section is "reserved" and you can not dynamicly show the header & footer sections. The only thing you can do is decide if they are shown on either the first, last or every page. I realy hope this will be an feature in an upcoming RDLC Version. I wish for a visibilty property of the header & footer section and a way to control the height of the section or another way to control the space that is used to print it.

clausl

Unfortunately, Headers and Footers are not dynamic in either RDLC 2008 or RDLC 2010. SSRS team is well aware of this limitation, so hopefully in next version we will have support for this, but I would not place any money on this hope/bet.

BUT there is a workaround for the footer takes up space on each page.
Funny enough the workaround is not to use headers and footers on your report. As I explained here http://mibuso.com/blogs/clausl/2012/10/03/simplifying-document-reports-in-nav-2013/ we really do not need to use Headers and Footers. For Document reports I think the standard reports are broken the way they use Headers and Footers. Really only thing I need in the Headers and Footers for is the Page No., but if the SSRS team gave us the possibility to use Page No. in the Body we don’t need to use Headers or Footers in Document reports at all.

Here is what you need to do:
Create a List and group this on i.e. “Invoice No.” In the simple example I have created(link below) I group on Customer No.
Then set checkmark in “Also at the end of a group” in “Page break options” in the “Group Properties”.
After the List control in your report layout, you then add a Rectangle which fits the whole page minus the margins of your report.
I set the Rectangle to fit the whole page because we cannot control that elements are place in bottom as we could do in Classic reports. When the rectangle fits the whole page I have full control where I place my fields.

I have created a demo reports which shows you how it works.
You can find FOB, TXT PDF here on SkyDrive with many other examples: http://sdrv.ms/Vf2vxc.
I have also added Report.rdlc and Dataset.xml, if you just want to run the report Offline as explained here: http://mibuso.com/blogs/clausl/2012/06/24/offline-preview-and-debug-reports-in-microsoft-dynamics-nav-2013/

/Claus Lundstrøm

deV.ch

Does this solution work with printable body data on the last page too? in the pdf on your skydrive you have "row"-data until one page before the last page. And ano the last page you have only the footer thing.

BTW: nice trick.

clausl

Yes you can do this. I this is a requirment it probably makes more sense to have the last pages shown for each Customer.

I have created new example where the last page is shown for each customer. Here you can see that I have body data printed in the last page which changes for each last page.

How did I do this? I added a new List outside the other list and Rectangle.

Download example here in FOB,TXT, PDF, XML and RDLC:
http://sdrv.ms/UWdRVL

/Claus Lundstrøm