SSRS Question - not programming
-
Can SSRS (Microsoft SQL Server Reporting Services) be configured to run a report and then email it to someone? The email server will be an Exchange OnLine (MS 365 for Education).
I don't think SSRS can. The underlying Sql can if you have Enterprise Edition. We had to roll our own that worked with Standard. This was a few years ago, but I think the code was found on Github. It was a starting point. I don't recall much more than that, and I am no longer with that company.
Jack of all trades, master of none, though often times better than master of one.
-
Can SSRS (Microsoft SQL Server Reporting Services) be configured to run a report and then email it to someone? The email server will be an Exchange OnLine (MS 365 for Education).
AFAIK, no, you can't. You can, however, send the user a link to an SSRS report that will open in the browser, with parameters.
Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles.
Dave Kreskowiak -
Can SSRS (Microsoft SQL Server Reporting Services) be configured to run a report and then email it to someone? The email server will be an Exchange OnLine (MS 365 for Education).
Or you can save it to a file and email it as an attachment.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
Can SSRS (Microsoft SQL Server Reporting Services) be configured to run a report and then email it to someone? The email server will be an Exchange OnLine (MS 365 for Education).
SSRS have a subscription option where you manage the published reports and have the report emailed to whoever at a scheduled time. The SQL server needs to be setup for email. (SSMS - Maintenance - Database Mail) This is available on the standard version if you have the appropriate rights.
A Fine is a Tax for doing something wrong A Tax is a Fine for doing something good.