I am trying to create a report to match exactly as in attached file using RDLC, that has three levels of data:
- Packing No
- PO No
- Item
Level 2 and 3 should come in a single column, to achive this I have tried using subreport:
- Column Grouping - If more than one PO arrives, column is repeating horizontaly instead of extending vertically
- Row Grouping - Two columns are created one for PO No, another for item details,instead on single column
- Subreport inside subreport - Here first subreport have Packing No as Parameter, second subreport has Packing No & Po No as parameter, in this case first row of RDLC alone displays all data correctly, subsequent rows are not able to receive the parameter and it displays error.
I came close but not able to complete, any solution will be greatly helpful to me.