Nav 2013 Invoice Report with fixed number of detail lines

gtr
Member Posts: 131
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.
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.
0
Comments
-
Hello,
I encounter the same problem. Did you find the solution?
Thanks.0 -
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.0 -
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions