April 21, 2016 at 6:35 am
Hi,
I have 1 dataset which is creating detail level report and summary level report in ssrs. I have to send this data on Email using SSRS subscription. I want to render summary on the email body and attached detailed report (excel format). But I think in SSRS we can have only one option enable for sending data over emails
Need your help for some work around.
Regards.
April 21, 2016 at 9:30 am
You're correct that when you send a report out by subscription, you can't send an attached file that differs from the email content.
If you want to make it so that the report is easily viewable in the email and then further data can be seen in the attachment, have you considered using drilldowns?
If a report is rendered in MTHML and the drilldown is by default not shown, the email will not display that content. When the recipient then receives the email and opens the attachment (it would need to be in xls(x)), they would be able to use the drilldown to view the details that previously weren't visible.
Does that help at all?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 21, 2016 at 11:16 pm
Hi,
Thanks for your reply.
I understood your solution but the problem is this solution wont work with me. My summary of dataset is going to be long and if I keep drill down of my detailed report in the mail body itself which has almost 20 columns would be very troublesome for end user to consume.
Hence was suggesting to get summary on the mail body and data which is at detailed level should come as an attachment.
Regards
April 25, 2016 at 12:18 am
Hi everyone,
Please can anyone help in this issue.
Regards.
April 25, 2016 at 2:24 am
As I said in my previous comment, you can't send a different report in the email content to that of the attached file. A single report can only send one render.
The only other option, if you don't want to go down the drilldown method, would be to two subscriptions. one with the summary in MHTML, the other with the attached file.
I assume you are looking to have have the summary in MHTML? You're reply to my previous post seem to imply that even your summary would be too large to render in email form. if this is the case, I'd simply suggest sending the attachment, with the drilldown available there instead.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 25, 2016 at 7:30 am
Hi,
Thanks for your reply.
Yes I want to send Summary in MHTML format. The summary itself has 7 different charts which are giving information on basis of different dimension. My dataset remain same for all 7 different charts.
If I make two different subscription then the end user would receive 2 different emails.
🙁 🙁 🙁
Regards
April 25, 2016 at 8:57 am
So, correct me if I'm wrong, the email you want you would like to contain 7 charts in it only. Then the attachment (xlsx?) will contain the detail to go with it.
Create the first chart. Then underneath it put a text box. Type some small text like "Show Chart 1 details" (what it says doesn't really matter),then change the text box's name to something defining too (click the text box so it is selected, but not being amended and press F4. Change the name in the General section to something like txtDispDets1). While you're there, also change the Hidden value to True in the visibility section, or change it in the right click properties menu, on the visibility pane.
Now add your first details table below. Create this exactly as you want it. Now select the table, and open the tablix properties. Navigate to the Visibility pane and select Hide for the "When the report is initially run" option and tick the "Display can be toggled by this report item" option. Then select the text box you just created in the drop down menu and click ok.
Repeat this for all your charts and tables, adding a new textbox each time.
When you preview the report, you'll notice that the items do not display. This is also true if you save to MHTM. If however, you save to xlsx this is not the case. This is because the text boxes to make the hidden table visible are also hidden. and cannot be unhidden. As a result the tables are displayed, but the text boxes are not.
It's a bit of an "odd" way to get around it, and I've no idea if this is intended behaviour or "happy coincidence", but it works on my VS2010 and SQL2012 deployment.
Let me know if that's what you're looking for and works for you 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply