Using VS 2005 to Edit SQL RS 2000 Reports?
-
I have some reports created with VS .Net 2003. The reports are running on a SQL RS 2000 server. Now I have VS 2005. When I tried to open the reports in VS 2005 it informed me that its going to update the reports. If VS 2005 updated the reports, would the reports be broken when they run on the SQL RS 2000 server? Is there anything I should be aware of?
Thanks.
-
YES... you get an error from the ReportServer itself stating it is the wrong version number...
Moe C -
I ran into this error but didn't have time to go back.
What do I need to do when upgrading to SQL 2005 is not possible at this time? Keep using VS .NET 2003?
Thanks.
-
Actually,
The only way to go back and forth is allow VS to do the upgrade to 2005, but to go backwards you'll need to edit the reports from 2005 to still use them in RS 2000 in notepad....
What you need to do is change the namespace referenced at the top of the XML file from ...
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
TO
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
and delete COMPLETELY the two sections with "InteractiveHeight" and "InteractiveWidth"
You can now upload the report to the RS 2000 instance.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
Thanks. I will give it a try.
-
OOPS, I had my namespaces reversed...but I'm sure you caught that.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
I haven't tried but thanks.
-
Jason,
When I upload a report saved in VS 2005 to a SQL 2000 RS server, I got The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ‘http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition’). (rsNotACurrentReportDefinition) . Is there a way to go around or VS 2003 is the only choice to edit the report?
Thanks
-
Did you edit the RDL in notepad and change the xmlns="" entry, and then upload through ReportManager?
This should work, I've done it many times.
You can't "Deploy" them from VS.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
VS 2003 is the only choice to edit the report ... i would stick with that...
Moe C -
MOE, I think you're missing my point. 🙂
You can edit the report in VS (any version). Save the file, locate the .RDL file on your PC, open in notepad and change the lines in my post above, then go to http:\\yourReportServer\ReportManager and upload the RDL there.
Like I said, I've done this many times as we haven't had the time to completely move everything from RS 2000 to RS 2005, but we did upgrade to VS 2005.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
Jason,
That was what I did. I opened the RDL in Notepad, changed from schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition to schemas.microsoft.com/sqlserver/reporting/2003/01/reportdefinition then uploaded the RDL using Report Manager. What am I missing here?
Since you said you've dove it many times let me go over to see if we are on same page. I have reports on a SQL 2000 RS server. The reports were created with VS 2003. Now the company decided to upgrade to VS 2005. I am trying to use VS 2005 to edit an exiting report and upload it to the report server but I got the error The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ‘http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition’). (rsNotACurrentReportDefinition). I changed the RDL file in Notepad to change the report definition but still got same error. I can keep using VS 2003 to edit the reports until the report server is upgraded to SQL 2005 but I prefer to use one version (VS 2005) only for all apps.
Thanks
-
OK, you seem to be doing it right. What I would suggest, is to download "edit" a report that you haven't modifed in 2005 yet. Check it's namespace (xmlns), it may be different that what I posted, but i doubt it.
If that doesn't do it, then I'm at a loss. Sorry! 🙁
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
save yourself the hassel and just use VS 2003 ... until your company is ready to upgrade the report server to 2005, just keep doing what you were doing before... i ran into the same problem.. save the headache for when you have to upgrade those reports to 2005... thats a whole lot of fun... take it easy
Moe C -
Moe is right on one point. It's really up to you which route you want to go. Either use my method, or continue to use VS 2003 until the upgrade.
It's you're call.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply