Grouping in rdlc reports query

chandrurecchandrurec Member Posts: 560
edited 2013-05-22 in NAV Three Tier
Hi all,

I am indenting Item ledger entry under item.

In ILE I am grouping by Location and Lot no.

so the ILE location code and lot no grouping is coming ok. But when I put the Item No displayed in body, only the first item no is displayed and then remaining item no is not getting displayed.

Actually I should get the output as follows.

Item 1

Location 1
Lot 1
Lot 2
Item 2
Location 1
Lot 1
Lot 2

If anyone knows. how to achieve this, kindly let me know.

Thanks in advance.

Regards,
chandru.

Comments

  • companycompany Member Posts: 89
    Hi,

    Try these steps.

    1. Insert a group in the layout

    2. Add the fields in the grouping : "Item Ledger Entry"."Item No.", "Item Ledger Entry"."Location Code" and "Item Ledger Entry"."Lot No.".

    3. Place the desired fields like "Item No.", "Location Code", "Lot No" and "Remaining Quantity" in the grouping row.

    Save the layout and run your report.

    Regards
    Vijay
  • clauslclausl Member Posts: 455
    Look at your dataset in Excel. Then do the filtering in Excel to mimic what you want to do in the Report layout.
    Then "copy" the filters you did in Excel to Report Layout in Visual Studio.
    This always helps me, when I'm not sure why things are not printing correctly.

    /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 :-)
Sign In or Register to comment.