We did an in-place upgrade of SSRS 2005 to SSRS 2008 R2. I had a report out there, "Budget vs Actual", which was running after the upgrade in 2008 R2, albeit using the old Yukon report processing engine. Now we are trying to simply upload it again (no changes) but we can't. Tried.. upload function in report managerreportserver endpoint ReportService2005.asmx (CreateReport)VS 2008 <deploy> command using all target SSRS types availableVS 2005 <deploy> command Every attempt fails with "... has a scope parameter that is not valid for an aggregate function". This is presumably an "auto-upgrade"-type error but I have no particular desire for that. So how do I get this report back in the catalog (exactly as it existed right after the in-place upgrade to SSRS 2008)? At the moment we don't have resources to undertake the work of revamping the RDL in the new post-2005 "on demand" schema. Thanks in advance.

In my experience scope errors have to do with using functions like Previous, InScope, Lookup, basically any function where you refer to the dataset or rowgroupings (in matrix reports). Aggregates are things like Sum, Avg, CountrRows, etc. For example using things like RowNumber("DataSetName") or CountRows("DataSetName") or InScope("RowgroupingName"). I would crack the rdl doc in notepad and look for anything in quotes and see if they still exist after the doc was upgraded.

Thanks for the tip. I don't want to actually fix the RDL (and in so doing convert/upgrade to the new format). I already know that it works using the Yukon processing engine that is included within SQL 2008 R2. I am simply not able to deploy to SSRS. Here is more info. I finally found out that I can upload it if I do nothing more than add a bogus/hidden 2005-based CRI as a placeholder. Apparently that is enough to tell SQL 2008 R2 to knock it off with the "auto-upgrade" at the time of report deployment. Is there any more standard way to upload an SSRS 2005 report to SSRS 2008 R2 without jumping thru these "auto-upgrade" hoops? David Beavon

If you open the 2005 doc in a 2008 BI Report project it will convert the report to 2008 for you (creating a backup of the original). You can test it on the preview tab and then upload it to SSRS. Might help you narrow things down a little

Hi David, SQL Server 2005 and 2008R2 Reporting Services use the different RDL schema. We cannot directly upload 2005 RDL reports to Reporting Services 2008R2 Report Server. We can upgrade the 2005 RDL reports to the new namespace. Here are some articles for your reference, please see: Planning for Report Authoring and Report Deployment: http://technet.microsoft.com/en-us/library/dd207009(v=sql.105).aspx Upgrading Reports: http://technet.microsoft.com/en-us/library/ms143674(v=sql.105).aspx Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Bin Long TechNet Community Support

Thanks for the links. The first one is especially helpful (and simultaneously a bit confusing). One thing I saw well documented is that SQL 2008 R2 supports the old RDL (2005-based) . It is clearly listed in the RDL version compatibility table. The repot in question ran just fine after the in-place upgrade (presumably using the Yukon processing engine). But after the unwitting removal of it I can't find a way to get it back into the SSRS catalog. The problem seems frustrating and even a bit silly at the same time. Please help! (Any suggestions are welcome. It appears we have a number of reports like this one which won't deploy anymore; and we don't have the resources to work on all of them at the moment. )David Beavon

Hello David, We can upgrade old reports(RDL 2005) to 2008 reports with new schema. If you want to RDL 2005 reports to Report Server 2008 R2, I recommend you that upgrade the reports by using BIDS 2008R2 and then them to Report Server 2008R2. Note: Please make a copy before upgrade RDL2005 reports. By the way, here is an article about "Considerations for Upgrading Reporting Services" for your reference, please see: http://technet.microsoft.com/en-us/library/ms143747(v=sql.105).aspx Regards, Bin LongBin Long TechNet Community Support

Hello David, We can upgrade old reports(RDL 2005) to 2008 reports with new schema. If you want to RDL 2005 reports to Report Server 2008 R2, I recommend you that upgrade the reports by using BIDS 2008R2 and then them to Report Server 2008R2. Note: Please make a copy before upgrade RDL2005 reports. By the way, here is an article about "Considerations for Upgrading Reporting Services" for your reference, please see: http://technet.microsoft.com/en-us/library/ms143747(v=sql.105).aspx Regards, Bin LongBin Long TechNet Community Support