Hello ,
We are using the SSRS for reporting purpose and email subscription so that reports can be delivered . We have a new ask today
Lets say we have dataset 1 ( which is small ) and Dataset 2 ( which is huge ) . The users wants a reports which should have dataset1( which is small ) in the body of the email and dataset2 ( which is huge ) as an attachment in excel .
Well I know that we can have two reports ( one delivering the Excel and the other small DS as Body ) , but I am not sure if both of the above ask can be done in a single report .
Anyone have any thoughts/suggestions on this ?
Thanks
Himanshu