This debate will never end. Should you use a case statement in the sql vs. iif in the report expression. It's all semantics.

Here is more on shared datasets.

OUTSTANDING! Thanks so much. This will help a great deal in our migration. Kudos to you!

This is a real keeper in my bag of tricks!

:-D:-D:-D:-D:-D:-D:-D

I have had the same disucssion with several folks and can see both sides of the fence. I think what blows the sp concenpt into the water is the...

Thanks Michael. Not to be a pest, but I am getting the following error:

Msg 9414, Level 16, State 1, Line 2

XML parsing: line 1, character 17, equal expected

You might want to try this. I use it all the time.

http://www.sqldbatips.com/showarticle.asp?ID=62

I agree, this has been troublesome, as some users do not understand the need to have a fully qualified email address in the .to field.

If this is greyed our, then...

Try this.

SELECT Catalog.Name, Catalog.Path, Schedule.NextRunTime, Schedule.LastRunTime, Schedule.StartDate, Schedule.RecurrenceType,

...

Thanks. It does seem to not bring back all the query text.

This is fantastic. We have been using it for a few months, and it beats using RSExecutionLogs database.

It seems there is a limitation on the command text though. ...

If you are happy being mediocre and just doing a job for a paycheck, then your standards are lacking. Someone once said 'Anything worth doing is worth doing well"....