Last post Oct 03, 2011 09:52 AM by GauravSingla
Sep 28, 2011 05:26 AM|micnie2020|LINK
Anyone have example how to do master-details reporting using .rdl?
Eg: I have two table
Order ID | Date Purchased | TotalBill
Order ID | SKU Code | Qty | U.Price |
The data will display like datagrid format.
When click on Order ID, then will expand showing order details.
Sep 28, 2011 06:02 AM|GauravSingla|LINK
I guess you can not create a report in which you can expand rows to see the details. May be i am wrong.
But i know of two ways this can be achieved not exactly but similar to the one you asked:
1) Create one report that will display Master data and create another report that takes order id as a parameter and display details for that order id. Now in the master report, Right click on OrderID textbox and choose properties - > Action. Link the textbox
to another report and choose the orderId parameter to pass the second report there. Now when you run the master report, there will be a link on orderId and when you click on it, it will show you the details for that orderid in the second report.
2) Create the query in such a way that it return all the required data in single select statement e.g master data as well as details data.
Now apply grouping on order Id and date Purchased and calculate Total bill in the report itself. You can also create a document map for easy navigation and viewing details for particular orders.
Oct 03, 2011 04:36 AM|micnie2020|LINK
I got the solution using Visual Studio 2008 / 2010 in report wizard, drilldown method.
Oct 03, 2011 09:52 AM|GauravSingla|LINK
Thanks for the information. Actually i never used wizard for creating reports. So i wasn't aware this could be done very easily.