April 13, 2014 at 11:32 pm
Months ago we upgraded a SQL server 2005 to 2008 R2 reporting server, and the reports are upgraded too.
I know that developers also need to open and save their reports in Visual studio so that the reports using new version of definition.
Because most of developers have 2008 ssrs, so they use BIDS 2008 recompile the reports and save into source control and deploy to the server.
But one of the developers didnot follow the process.
So when I today look at the reports, and I cannot open it in SSRS 2008, actually I can open it but it renders directly in to html code. no design view
I found out by downloading that report from report manager, and see the xml file top is like this
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
So I guess he used visual studio 2010 edited the reports and deployed to the server.
My question is : I remember visual studio 2010 does not have SSRS projects model, it can only edit local c# , no SSRS reports. So how this 2010 comes from?
What version is that for SSRS reports?
secondly, that report definition is 2010, but the server is SSRS 2008 R2, so does that mean 2010 report works on 2008R2?
How can I open this report in SSR2 2008 to edit it?
Thanks for help in advance.
April 14, 2014 at 12:15 am
sqlfriends (4/13/2014)
Because most of developers have 2008 ssrs
FYI 2008 and 2008 R2 create slightly different RDL.
My question is : I remember visual studio 2010 does not have SSRS projects model, it can only edit local c# , no SSRS reports. So how this 2010 comes from?
BIDS that comes on the SQL 2008 R2 CD is built on VS 2010. The developer likely opened it in this.
secondly, that report definition is 2010, but the server is SSRS 2008 R2, so does that mean 2010 report works on 2008R2?
BIDS 2008 -> Built on VS 2008
BIDS 2008 R2 -> Built on VS 2010
How can I open this report in SSR2 2008 to edit it?
I saw an article once that you can convert the XML from 2008 R2 back to 2008 manually, by editing the XML file by hand to remove R2 references. It might be easier to just recreate the report.
April 14, 2014 at 9:57 am
good and clear answer, that is exactly the answer I am looking for.
Thanks,
April 15, 2014 at 8:02 am
You might also see if you have an old copy of the original rdl to upgrade.
Many times I would start by making a copy of the whole project just so if something like this happened, I could start over.
April 15, 2014 at 9:55 am
Thanks, we check in all the files in subversion. so we have old copies, I do make another copy of the entire project.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply