Creating reporting services Invoice format

icapilla

Hello,

I'm trying to create a invoice format, I managed to use the number of print copies,
but I can't make it print the footer on the last page of each copy.
I can't use standard Navision reports because totals in these reports are calculated at the end of the last line
and I want to be calculated at the end of the page.

somebody can help me?,

manikandan

icapilla wrote:

Hello,

I'm trying to create a invoice format, I managed to use the number of print copies,
but I can't make it print the footer on the last page of each copy.
I can't use standard Navision reports because totals in these reports are calculated at the end of the last line
and I want to be calculated at the end of the page.

somebody can help me?,

Hi,
Why don't you use Group Header and Footer concept.
:-k
Regards,
Muthusubramanian.M

clausl

Sounds like you want to do Transfooter and Transheader which is not supported in RDLC reports.

But I have described how you can workaround this and create totals at the end of each page in RDLC reports here:
http://blogs.msdn.com/b/nav/archive/2011/06/06/transfooter-and-transheader-functionality-in-rdlc-ssrs-reports-revisited.aspx

/Claus Lundstrøm

icapilla

Hello,

I think the option I can use to get this data is the option of transheader and transfooter, but I have one last problem, I want to put the number of pages per document (I´m triying to print many documents, for expample form inovice 0001 to 0150), but the problem is that I don't know how many pages of each document is going to print 1 of 3 ... 2 of 3 .... 3 of 3, I managed to get the page number with the following code:

Public Function GetGroupPageNumber(NewPage as Boolean, pagenumber as Integer) as Object
  If NewPage
    offset = pagenumber - 1
  End If
  Return pagenumber - offset
End Function

But I have the problem, I don't know the last page to concatenate "page" of TotalPages.

thanks in advance for your repleis

clausl

This cannot be done as I see it in the current versions of RDLC. That goes for RDLC 2005, supported in NAV 2009 and RDLC 2008 supported in NAV 2013.
We need features which are introduced in RDL 2010. Confused read my blog post about different the different versions of RDLC here:
http://mibuso.com/blogs/clausl/2012/08/08/rdl-vs-rdlc-versions-and-dynamics-nav/

So we need to be able to reset page numbers as Robert explains here:
http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx
And we don't get this ability before NAV supports RDLC 2010 released with Visual Studio 2012.

If anybody can figure out how to do "x of x" on Groups in RDLC 2005 or RDLC 2008 and present how this is done, I will personaly buy this person dinner in a nice restuarant.

If this was simple I guess it would have been implemented in 206, but it is not. Neither in NAV 2009 or NAV2013.

/Claus Lundstrøm

icapilla

Thanks for your ideas and suggestions,

based on your responses I gather it's impossible to print the footer on the last page of each document if i have more than one pages per document, because there is no way to know which is the last page of each document when I print many bills in a range????

thank you for everything

clausl

You can easily print i.e. Page 1, Page 2 in the footer based on the current Group. That is not hard to do.

But you cannot print Page 1 of 2, Page 2 of 2, before we get support for RDLC 2010.

/Claus Lundstrøm

mihail_kolev

actually you can, but it's a lot of coding and imagination (not only RDL side but in NAV too)

icapilla

clausl wrote:

You can easily print i.e. Page 1, Page 2 in the footer based on the current Group. That is not hard to do.

But you cannot print Page 1 of 2, Page 2 of 2, before we get support for RDLC 2010.

/Claus Lundstrøm

Hi Claus,

I think my explanation is not entirely clear, i know how to print page 1 or page 2, my problem is:
if i print for example 3 bills in a row, from number 100 to number 102 and each bill has 4 pages I need to put the footer only in last page of each bill, i try to do that with the total number pages in RTC, but the problem is that nav does not recognize when you change the invoice number and it prints the footer only in the last page or all pages.

How can i print the footer only in the last page of each invoice???

I tried many things and i don´t haver more ideas... ](*,) ](*,) ](*,) ](*,)

thanks,

Valery_Grigoriev

icapilla wrote:

clausl wrote:

You can easily print i.e. Page 1, Page 2 in the footer based on the current Group. That is not hard to do.

But you cannot print Page 1 of 2, Page 2 of 2, before we get support for RDLC 2010.

/Claus Lundstrøm

Hi Claus,

I think my explanation is not entirely clear, i know how to print page 1 or page 2, my problem is:
if i print for example 3 bills in a row, from number 100 to number 102 and each bill has 4 pages I need to put the footer only in last page of each bill, i try to do that with the total number pages in RTC, but the problem is that nav does not recognize when you change the invoice number and it prints the footer only in the last page or all pages.

How can i print the footer only in the last page of each invoice???

I tried many things and i don´t haver more ideas... ](*,) ](*,) ](*,) ](*,)

thanks,

We use Group Footer instead of Footer and control the visibility of the following formula:

=Switch(Fields!TotalPage.Value=1,False,Fields!TotalPage.Value>1,IIF(Fields!
CurrPage.Value<>Fields!TotalPage.Value,TRUE,FALSE))