Report Delivery Options

Question

Report Delivery Options

2Tall

SSChampion

Points: 14644
More actions
August 4, 2008 at 7:01 am

#190439

Hi. I am pretty sure what I want to achieve is possible in SQL Server 2005 Standard x64 although my searches have failed to provide a clear answer so here I go with my post.
I (will) have (come go live) a number of SQL reports that end users would like delivered via email (scheduled for daily delivery). I have been playing around in Report Manager. When I drill down to a report select Subscriptions / New Subscription the Report Delivery Options - Delivery by lists Windows File Share as the only option?
So what I would like:
Report A emailed daily to Exchange Distribution Group 'A'
Report B emailed daily to User 'Z' etc.....
Hope I am making sense!
Many Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

toolman-352714 SSCrazy Points: 2495 More actions · Answer 1

Sounds to me like you're not configured for email delivery. Check with your DBAs (or check yourself) to make sure your SSRS configuration includes the email option and that you're set up correctly with your exchange server. I'm not a DBA so I can't take you much further than that.

HTH

[font="Comic Sans MS"]toolman[/font]
[font="Arial Narrow"]Numbers 6:24-26[/font]

2Tall SSChampion Points: 14644 More actions · Answer 2

I will take a look.

Regards,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

ganatra.neha-768406 Old Hand Points: 343 More actions · Answer 3

The report server e-mail delivery extension is not configured by default. You must use the Reporting Services Configuration tool to minimally configure the extension. To set advanced properties, you must edit the RSReportServer.config file.

Check this article out for report server delivery options configurations

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/b838f970-d11a-4239-b164-8d11f4581d83.htm

sgmunson SSC Guru Points: 110640 More actions · Answer 4

Also, you may want to look at Data Driven Subscriptions. This provides a means of using a query to determine the e-mail addresses to be used as recipients. Of course, the e-mail feature has to be set up first, as indicated by previous posts. However, I'm using this feature and it's truly slick. You can even have the query specify the report format separately for each recipient (from among the supported export formats), and whether or not to include a link back to the original report, and numerous other things. Check it out.

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

2Tall SSChampion Points: 14644 More actions · Answer 5

Thanks to all that posted. I have configured SSRS as suggested, now I need to have aplay. I will check out that link and have a read up.

Thanks,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

2Tall SSChampion Points: 14644 More actions · Answer 6

Hello again. I have managed to succesfully schedule email delivery of reports. One final question. A report contains grouping allowing users to expand the Customer Name to reveal the report content. When the report is delivered in .pdf format the group is collapsed so the report data is not visible. Can I control this to display the group in an expanded state or do I have to modify the report to be expanded by default?

Thanks,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

sgmunson SSC Guru Points: 110640 More actions · Answer 7

PDF is a fixed format situation. You'll have to export in Excel to get that functionality, at least last I knew anyway.

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

2Tall SSChampion Points: 14644 More actions · Answer 8

Thanks Steve, I will try that.

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper