Problem showing Rows in Nav 2013R2 Reports

VectorKVectorK Member Posts: 86
edited 2014-12-13 in NAV Three Tier
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:

Imagen2_zps50be72ac.png

Here is my rdlc layout (VS2012)

Imagen3_zpscec5dab2.png

Imagen4_zpsfcd0801e.png

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

Imagen1_zps5ebb6c8b.png

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

Comments

  • VectorKVectorK Member Posts: 86
    Dear Mohana,

    Thank You very much. I'm really sorry :cry: 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 :cry:

    Any idea?
    Thanks again.

    Kind Regards, :wink:
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    It works if you give the condition in each row correctly
  • VectorKVectorK Member Posts: 86
    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
  • VectorKVectorK Member Posts: 86
    After implemented the solution, exactly as shown at your video, in the standar sales order confirmation, this is what I get:

    First execution...

    Imagen2_zpsc463e4d5.png

    Imagen3_zps75f26eaf.png

    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...

    Imagen4_zpsb854531d.png

    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

    Imagen5_zps5dd7ba5c.png

    And this is what the report shows
    Imagen6_zps42632e3b.png

    As seen above, much more than 10 rows are showed :cry:

    Thanks again.
    Kind Regards
Sign In or Register to comment.