There isn't a tool within ReportManager to copy another server. Could you redploy the reports from the new server from BIDS? You would need to re-setup security though...

Have you considered a database backup/restore?

You're welcome!

Use backup/restore...

If you're calling the report from a URL, add &rs:ClearSession=True. This will cause the broswer to refresh the report everytime it's called.

You may also want to add a check for zero in the denominator or you will get a didvide by zero error. Also, be aware an iif block will...

Yes, you can restore the ReportServer from a DB backup. The only issue you may run into is regarding the encryption key of the RS. Do you have...

No, merge is only available at design time. What you could do is create a second row with the merged columns and then based on a value, set the...

Have you looked into using ReportBuilder?

I've built a custom web app in ASP.NET/C# using the SSRS API's, but this is a failry involved process but can be done. The built-in SSRS parameters are pretty...

There's a great 4 part guide at MSSQL Tips that starts here... http://www.mssqltips.com/tip.asp?tip=1687. I used it for our installation and it was invaluable.

Is SSIS installed on the server? I remember trying to create a plan where is was not and the error was cryptic and had nothing to do with SSIS...

Out of curiosity, why would you want to run SSRS with a compatibility level of 90 as these databases are internal only.

No, not possible.

Are you getting errors in the function. The code should be something like...

Function DispTypeString(value1 AS DateTime, value2 AS DateTime) As Long

Dim NumberOfDays AS Long

NumberOfDays = Datediff("d",value1,value2)

Return NumberOfDays