John-476812 (2/4/2010)

---

Clearly I am having an ID10T moment. I cannot find the download link to the zip archive ANYWHERE. I have looked all over the article for about...

It is possible to change the limit for the purge of the execution log. Shown in the images for the Diagnostic Reports are the configurations for one of our...

Thanks denglishbi - I expanded upon your statement to show the FIRST query in a report:

;with RS as

(

SELECT [Name],

CAST(CAST([Content] AS VARBINARY(MAX)) AS XML) AS reportXML,

CAST(CAST(CAST([Content] AS VARBINARY(MAX)) AS XML)...

Ahh - now I understand. If you are capable of it, take a look at the "Content" column in the ReportServer.Catalog field. I would imagine it would be...

Roger...

Typically I like developing reports with a procedure (kept within the database) and an RDL file (which executes the procedure). To make these as easy for deployment as possible...

Thanks for the feedback Kevin - that data type should have been included.

I replicated the error (by creating a table with a GUID) and then modified the section that limits...

Thank you both...

It doesn't appear as if the "&rc:ClearSession=true" option worked - that was the type of fix I am looking for. I am reluctant to request a change...

Thanks…although I believe what that thread states only works when a report is being deployed from BIDS (as opposed to being uploaded via Report Manager).

In BIDS, it is perfectly fine...