Problem showing Rows in Nav 2013R2 Reports

VectorK

Hi Experts,

I need to show just a fixed number of rows per page (five in this case) in a new custom rdlc report.
Here is my dataset:



Here is my rdlc layout (VS2012)





As showed above, there is a group called "Page" in order to force the page break.

Looks nice and easy and this is what I get when the report runs



As you can see, the report shows seven rows when the two last rows should be showed in the next page.

Do you know if there is a way to fix this? I'm getting crazy about it ](*,)
Thanks in advance

Kind Regards

mohana_cse06

Please check this blog
http://mohana-dynamicsnav.blogspot.in/2013/09/fixed-no-of-lines-in-nav-2013-rtc.html

VectorK

Dear Mohana,

Thank You very much. I'm really sorry but as showed in the video, your solution doesn't work at all, as the page number is the same in every page. Works only with the sales line detail. If you need to print information which depends of the sales line (i.e. comments, shipment info, and so on) it doesn't work neither

Any idea?
Thanks again.

Kind Regards,

mohana_cse06

It works if you give the condition in each row correctly

VectorK

Dear Mohana,

This is your code

Public Function SetDocLength(NewData as boolean,Group as object,Outputno as integer )
  If (NOT NewData) AND (prevOutputNo = OutputNo) AND (DocumentNo = Group) Then
      FixedLenth = FixedLenth + 1
  ELSE
      FixedLenth = 0
  End If
 DocumentNo = Group
 prevOutputNo = OutputNo
End Function

Whats the meaning of the first parameter (NewData) in the function?
Wouldn't FixedLenth variable be initializated by One instead Zero?

Thanks again
Kind Regards

VectorK

After implemented the solution, exactly as shown at your video, in the standar sales order confirmation, this is what I get:

First execution...





As seen above, the report shows eleven rows on page, and this is, in my opinion, because FixedLenth variable in the SetDocLength VS function, should be initialized by 1 instead of 0.

Let's go to the next page...



As seen above, report shows page number one instead of page numer two. In my opinion "Overallpagenumber" should be used in this case.

Second Execution

It's time now to show internal and assembly information



And this is what the report shows


As seen above, much more than 10 rows are showed

Thanks again.
Kind Regards