Can't you pickup the RDL files from filesystem or from the ReportServer after deployment. Haven't used ProClarity' before, but the actual report file is deployed as the RDL.

Not sure whether this will perform any better but if you create two columns (1 is the identity) and then the identity column

DROP TABLE dbo.test

GO

CREATE TABLE dbo.test (id bigint...

I'm having a similar problem. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=241903

Have you checked the report execution properties and the web server content expiry settings?

I managed to get the data to refresh by making the...

Sorry it was actually a walk through. Did post the comment that there should have been a solution download.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/AdHocRepSr.asp

If you're on SQL 2000 try the sample from MSDN, had downloaded a sample earlier, but cant find the link now.

Are you using 200 or 2005. SQL Reporting Services has the Report Builder which sounds like just what you're looking for. Check out http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

From BOL

sp_recompile

Causes stored procedures and triggers to be recompiled the next time they are run.

To avoid the mesage being returned to the client, you could create a...