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.
0
Comments
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
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
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 :-)