SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS version issue


SSRS version issue

Author
Message
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10061 Visits: 4195
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.
Cody Konior
Cody Konior
SSC Eights!
SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)

Group: General Forum Members
Points: 999 Visits: 1110
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.
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10061 Visits: 4195
good and clear answer, that is exactly the answer I am looking for.


Thanks,
Greg Edwards-268690
Greg Edwards-268690
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4112 Visits: 8592
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.
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10061 Visits: 4195
Thanks, we check in all the files in subversion. so we have old copies, I do make another copy of the entire project.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search