Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS version issue Expand / Collapse
Author
Message
Posted Sunday, April 13, 2014 11:32 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 1,749, Visits: 3,153
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.
Post #1561324
Posted Monday, April 14, 2014 12:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:34 PM
Points: 211, Visits: 819
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.
Post #1561328
Posted Monday, April 14, 2014 9:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 1,749, Visits: 3,153
good and clear answer, that is exactly the answer I am looking for.


Thanks,
Post #1561545
Posted Tuesday, April 15, 2014 8:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:29 PM
Points: 1,211, Visits: 6,540
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.
Post #1561883
Posted Tuesday, April 15, 2014 9:55 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 1,749, Visits: 3,153
Thanks, we check in all the files in subversion. so we have old copies, I do make another copy of the entire project.
Post #1561953
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse