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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSRS Export to Excel ( Parent and Child Details)

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 , OrderCount
101 XXXX 5
102 YYYY 10

Order Details ( Child Details)

ORDERID, Date , Amount
501, 02/10/15 100
502, 02/10/15 200
503, 02/10/15 300
504, 02/10/15 302
505, 02/11/15 305
   

- Advertisement -