I would try this instead and skip the procedure.

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69257/

This only READS the log data and doesn't insert anything.

I can tell you from my most recent experience, that for some reason they think the network guy can do what the DBA does. It was a loosing battle...

I do have them in a central management server. Thanks for the tip.

Did you check the schema references in the report, so that it points to http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition

In the ExecutionLogview3, does it indicate that you are using more than one server...

It's been some time since I looked at this but you may want to test your stored procedure and make the value of the item in question as varchar(max) as...

Stacia,

I tried what you suggested, but sadly the results are the same.

I created a variable call varExecutionTime, set it as read only and the value as Globals!ExecutionTime

Assigned the expression in...

I noticed today that some data sources where being missed using the schemas listed in the data sources.

If you are using Sharepoint 2010 with SSRS then you will want to...

Try this...then circle back to fill the nulls (linked datasources)

SELECT DISTINCT Cat.Name AS Reportname, dst.Name AS DataSetName, Dsc.Name AS DataSourceName, Cat.Path

FROM DataSets...

You can start by running this query.

SELECT Dsc.name DataSourceName,

Cat.path,

Cat.name AS Reportname

FROM ...

I can't advise you in deploying in such a manner, unless you are using some sort of custom .net application with the report viewer control.

Those reports are designed to be...

Are you no longer deploying them through bids?

Yes, these reports will work fine in 2012. With sharepoint intergration the ExecutionlogView3 is on the farm where the reportserverdb lives.

This is the primary view for these reports.

Mike. Here is a couple more to add to this package. I find myself dealing with the GUID's a lot for the ReportCaching that we are using. ...