Sunday, February 12, 2012

Converting reports from 2000 to 2005

I am trying to convert reports from reporting services 2000 to 2005. I
did not open the solution that contained the reports because I wanted
to start fresh with a new structure. I added the projects and brought
the existing reports in. My question is, I am findingt the only way to
convert the reports is to open them in design view and specify that I
want to convert them at the prompt. After a little digging, it
appeared the only different was the report declaration at the top:
2005:
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
2003:
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
Since it is about ten times faster to open the report in xml (code)
view, I thought maybe I could just do a search and replace on the two
lines above, or at least copy over them, and then save all. I have
over 100 reports and it would be pretty time consuming to do a
conversion on each. Anyway, my question is is this the only thing I
need to do to convert a report or will I screw up my reports doing it
this way. I did one and it seemed to work.
Any advice is appreciated.I don't know. I think you are playing with fire. What if one of your reports
has something different that requires more. I would think you could do a 100
reports in about an hour. A boring hour but it is the safest way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephen" <switter@.enpathmed.com> wrote in message
news:1142439465.876284.160770@.p10g2000cwp.googlegroups.com...
>I am trying to convert reports from reporting services 2000 to 2005. I
> did not open the solution that contained the reports because I wanted
> to start fresh with a new structure. I added the projects and brought
> the existing reports in. My question is, I am findingt the only way to
> convert the reports is to open them in design view and specify that I
> want to convert them at the prompt. After a little digging, it
> appeared the only different was the report declaration at the top:
> 2005:
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> 2003:
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> Since it is about ten times faster to open the report in xml (code)
> view, I thought maybe I could just do a search and replace on the two
> lines above, or at least copy over them, and then save all. I have
> over 100 reports and it would be pretty time consuming to do a
> conversion on each. Anyway, my question is is this the only thing I
> need to do to convert a report or will I screw up my reports doing it
> this way. I did one and it seemed to work.
> Any advice is appreciated.
>

No comments:

Post a Comment