Nav 2013 Invoice Report with fixed number of detail lines

gtr

Hello,

I have simplified the standard invoice report 205 (no dimension or shipment information)
I need to print a fixed number of lines per page (lets say 20)
I saw some old posts but without any solution, just some hints.

I created a group grouping on Ceiling((RowNumber(Nothing)) / 10) as found on http://www.mibuso.com/forum/viewtopic.php?f=32&t=52174&view=next

But I get an error when compiling (Error while validating RDLC content).
As I'm on a french system the rest of the message is in french (see attached file)
It seems to be a problem on the function rownumber with a sort of "extended parameter" ?

I'm not so sure about what I'm doing in Visual Studio.
My 2 groups are :
Group1 (that I added)
=> Table_Lines_Group1 (coming from the standard report)

Do you have any idea what I did wrong and what I can do to get it work ?

Edit :
The main problem on this report was not initially to have a fixed number of lines - but to get all informations after the detailed invoice lines into the footer.
First I thought that I could get it work using the methode on http://blogs.msdn.com/b/nav/archive/2011/06/06/transfooter-and-transheader-functionality-in-rdlc-ssrs-reports-revisited.aspx, but the problem is that I could not find any help about this hashtable - If there is any way to get the information in the VATAmountLine Table into the footer, it would be very helpful.

mcorvaisier

Hello,

I encounter the same problem. Did you find the solution?

Thanks.

gtr

Yes I have found a solution - perhaps not what i wanted but it seems to work
I inserted a Integer Dataitem between detail and footer Dataitems.
Then I calculated the number of blank lines that have to be inserted so that the footer is allways on the same place and "setranged" this new Dataitem on this value.
In the dataitem I declared a variable on the number of blank lines so that this can be used in VisualStudio.
Then in VisualStudio I inserted a matrix grouped on this variable

Hope this helps ...
If somebody has a better solution - I'm always interested.

mohana_cse06

Did you check my blog video?
http://mohana-dynamicsnav.blogspot.in/2013/09/fixed-no-of-lines-in-nav-2013-rtc.html