NAV 2013 Report Query

chandrurecchandrurec Member Posts: 560
edited 2013-07-03 in NAV Three Tier
Hi All,

I have created a new report in NAV 2013 with Purchase Header as parent data item and I am indenting Purchase Line and Purch. Comment line one line below Purchase Header. then I am designing the Dataitems in rdlc. And after it when I run the purchase quote report I am getting space after purchase line and purchase comment line but the values are coming properly.

I have specified the link for both purchase line and comment line.

If anyone knows the reason for this unwanted space, Kindly let me know.

Thanks in advance.

Regards,
chandru.

Comments

  • clauslclausl Member Posts: 455
    You need to filter out the rows in your dataset which you do not want to show in your Tablix.

    If I am not sure I always make the filter in Excel first(About this report), to visualize what I need to show.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • Kau_147Kau_147 Member Posts: 84
    Dear chandrurec,

    I guess in RDLC report, you print the data on Page details (Page Header, Details, Footer).

    1) For purchase Line details, select the row & in properties -> Visible -> expression -> write the following code :
    =IIF(Fields!Purchase_Line__Document_No__.Value="",TRUE,FALSE)

    2) For purchase Comment Line details, select the row & in properties -> Visible -> expression -> write the following code :
    =IIF(Fields!Purch__Comment_Line__No__.Value="",TRUE,FALSE)
    I belive it will work & resolve your issue.

    Thanks & Best regards,
    Kavita Manish Mutha
    Best Regards,
    Kavita Mutha
Sign In or Register to comment.