Transheader and Transfooter for Multiple Document Nav 2013?

clausl wrote:

If none of my above blogs solves your problem I'm curious to understand why. So we can share this with the comunity, and hopefully with a solution ;-)

/Claus Lundstrøm

clausl wrote:

If you are not on NAV 2013 R2, you need to use this solution:

http://mibuso.com/blogs/clausl/2013/09/ ... ps-part-1/

Let me know if this works for you.

/Claus Lundstrøm

clausl wrote:

Easiest for me is of course to tell you just to upgrade to NAV 2013 R2, because this is so easy to do in NAV 2013 R2 as I explain in my blog post.

But upgrading to NAV 2013 R2 might not be so easy for you, so let me explain how to this, download my new solution here: http://sdrv.ms/1bkX1HJ

1. Add this custom code:

Private NewGroup As Double = 0

Public Function SetGroupNo(ByVal val As Double) As Double
NewGroup = val
Return val
End Function

Public Function GetGroupNo() As Double
Return NewGroup
End Function

2. Create hidden textbox in footer with following Expression:

=Code.SetGroupNo(ReportItems!No_CustomerGroupHeader.Value)

3. Change the Visibility Expression on the Transfooter textbox in Page Footer to this:

=iif(ReportItems!GroupDone.Value OR Code.GetGroupNo() = 0, TRUE, FALSE)

4. Change the Visibility Expression on the Transheader textbox in Page Header to:

=iif(Globals!OverallPageNumber > 1, Code.GetGroupNo() <> ReportItems!No_CustomerGroupHeader.Value,TRUE)

5. Now add a List control in the Body and and set to be grouped on CustomerNo and set it to Page break options to “Between each instance of a group”

This way you transheader and transfooter will work on multiple documents in RDLC reports in NAV 2009 and NAV 2013.

Notice that if the group total overflows to the next page you will not get Transheader shown. To solve this small issue you will need to upgrade to NAV 2013 R2 and start using the new feature ResetPageNumber in RDLC 2010.
Let me know if this solves your problem.

/Claus Lundstrøm

clausl wrote:

Sure I can do it in NAV 2013, it also makes more sense to do this in RDLC 2008.
Please find the solution here on my SkyDrive:http://sdrv.ms/1bPKm2p

Notice that my Table header is not repeated, when the Group total is all alone on the page. It would say this is a clear bug in RDLC 2008 because in RDLC 2010 the Table header is always repeated.
In my example this happens if have exactly 5 lines, if I have 4 lines the Group total will be shown on same page and if I have 6 lines, I have the last line is printed on next page with Group total.
In a real scenario this would of course always be more lines, but there will always be a break point where the Group total could be alone on next page. And here it is pretty bad that the Table header is not repeated on this page. This is of course only if you important information in the Table header. So just another bug in RDLC 2008 :-( But besides this issue my Transfooter and Transheader works on multiple documents in NAV 2013.

ReportItems I'm using on the Page Footer because when using ReportItems I can always check what is on the actual page. In this example I check for the Value in the TextBox GroupDone. This TextBox has expression that will tell me if we have reached the last line in the Group, if Yes, it will be TRUE, if not it will of course be FALSE.

Globals!OverallPageNumber in RDLC 2010 is the same as Globals!PageNumber in RDLC 2008. So Globals!PageNumber in RDLC 2010 is actually new, because this is the value we can reset in RDLC 2010.

I hope you can get it working now in your report, now that you have a working example in NAV 2013.

/Claus Lundstrøm