This MS technet video walks you through all the steps needed to setup a report subscription based on your requirements.

http://technet.microsoft.com/en-us/sqlserver/Video/dd420576

Just a note to close this topic out, my original problem was because I had the top of the list set below the actual top of the report, so initially...

You could create an SSRS report that will do this. Base your query off the job id for each backup job and then using that job id in the...

I did something similar to this by setting up a subscription to the SSRS report that occurred once (in the past so it wouldn't actually run) then created a SQL...

very helpful article, thanks for posting this!

Thank you Jeff,

Your solution you presented in the article makes so much sense and is very easy to follow. It will come in handy as I'm going through a...

You could create a new report that was made up of sub reports for each of the the 5 current reports.

If you do go with Excel 2007, you'll have to remember to change the file type to xlsx during the Export process as SSRS2005 and 2008 default to saving files...

I've worked with SharePoint 2003 & 2007 and to me it seems like a good solution for an out of the box corporate intranet. The problems I've seen with...

In BIDS 2008, go to the "Report Data" tab and right click on the "Parameters" folder to add a new parameter. It will take you through all the steps...

That's too bad, i guess I'll try to figure out another way around this problem. Thanks for the post.

I usually create two datasets:

1. StartDate

SELECT CAST((CONVERT(varchar(10), GETDATE()-9, 101)) AS DATETIME) AS StartDate

2. EndDate

SELECT CAST((CONVERT(varchar(10), GETDATE()-2, 101) + ' 23:59:59') AS DATETIME) AS EndDate

Then set the parameters @StartDate and @EndDate...

Coming from a novice point of view, I can't understand why cursors are really even used? They seem so much more complicated than anything set-based in SQL. I'd never...

Although it is kind of depressing, I'd highly recommend "The Wrestler". Very well done and realistic, just a really good movie.

Is it possible for you to use the built-in "Report Viewer" webpart included in SharePoint in order to display this particular SSRS Report? Since this webpart is included with...