Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Thiyagarajan
Starting Member
1 Post |
 Posted - 2015-02-26 : 04:25:21
|
| Team,We are scheduled SSRS report daily to export report into excel and send to client via email subscription. In Excel report client requesting parent and child data in separate sheets in Excel.In below example When users receives excel file and clicks OrderCount column value (5) in Vendor Details sheet need to have Order detail in separate sheet in same Excel report.Please let us know whether it is possible in SSRS 2008 R2.Vendor Details (Parent Details)VendorID, VendorName , OrderCount101 XXXX 5102 YYYY 10Order Details ( Child Details)ORDERID, Date , Amount 501, 02/10/15 100502, 02/10/15 200503, 02/10/15 300504, 02/10/15 302505, 02/11/15 305 |
|
|
|
|
|
SSRS Export to Excel ( Parent and Child Details)