Hi..it’s been awhile I didn’t post anything. Lots of thing happened since my last post. I know that I have to make some time to my blog 🙂
In this post, I’d like to share my careless experience by installing two version of BIDS in my work laptop that cause a delay for my team to deploy the report that I’d worked on. So, if you happen to have SQL2008R2 and SQL2008 installed on the same machine AND happen to modify one your RDL file, I promised that you won’t be able to open it in SQL2008 BIDS, which I thought it should because it’s still SQL2008 (silly assumption).
Anyway, to solve the issue OR to convert the RDL back to SQL2008 version, open your RDL file with any text editor and to do the following two replacements:
1. Schema
Look for:
<Report xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner” xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition“>
Replace it with:
<Report xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner” xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition“>
2. Look for:
<ReportSections>
<ReportSection>
AND its pair:
</ReportSection>
</ReportSections>
If you found it, remove it.
Save the RDL file and ta-da…you can open it again in BIDS 2008 without losing your work.
Hope this post help you.
Cheers,
Uzzie
QUICK NOTE:
Just be careful when you copy and paste Schema section from here into your RDL because the double quotes will turn to some funny character. You need to replace it with correct double quotes.
September 2, 2009 at 8:22 am
You saved my day.
Thanks a million.
October 1, 2009 at 6:15 am
I modified .rdl as suggested.
Opening it in BIDS somehow adds the schema element and ReportSections,
the modified TestReport.rdl is renamed as
TestReport – backup.rdl automatically!
😦
Any ideas no how to fix it?
I uninstalled Sql Server 2008 R2 CTP, uninstalled Visual Studio 2008 and reinstalled VS 2008.
Still getting the same error.
October 1, 2009 at 9:00 am
Hi Swetha,
You are suppose to replace the schema element and reportsection, not adding.
Can you send me your RDL (modified)? I can help you to have a look.
Cheers,
Uzzie
October 1, 2009 at 11:31 am
Hi Uzzie, thanks for the reply. Replacing is what i did. Sure i will send you the .rdl file.
Would you like me to mail it to you?
October 1, 2009 at 11:32 am
CWP
e3d72d99-7278-4e79-85da-914be696c30d
None
STATE_NAME
System.String
CWP
SELECT STATE_NAME
FROM USStates
1in
0.22in
true
true
STATE NAME
Tahoma
11pt
Bold
White
textbox2
LightGrey
Solid
SteelBlue
2pt
2pt
2pt
2pt
0.21in
true
true
=Fields!STATE_NAME.Value
Tahoma
STATE_NAME
LightGrey
Solid
2pt
2pt
2pt
2pt
After
true
true
Detail
Detail_Collection
Output
true
DataSet1
0.36in
0.43in
1in
true
true
States
Tahoma
20pt
Bold
SteelBlue
textbox1
0.36in
5in
1
2pt
2pt
2pt
2pt
0.79in
5in
1in
1in
1in
1in
en-US
true
efcb6653-df60-4cbc-be41-bd6a50ce2da1
Inch
October 1, 2009 at 11:35 am
oops. tried to paste the rdl in comment box. Please discard the above message. The tag names are not visible. Only the values are shown.
April 29, 2010 at 4:16 am
Very handy that, thanks.
As an update to this, my 2008 R2 must be even newer so I had to update the xmlns value from:
..xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition”..
and remove the value:
..xmlns:cl=”http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition”..
August 14, 2010 at 10:50 pm
Hi Oliver,
Thanks for your comments.
Cheers,
Uzzie
August 14, 2010 at 5:19 am
Brilliant! Thanks. You saved the day.
As a side note, I noticed a slight difference in the tag section in my report. Mine looked like this:
So we had an extra xmlns:cl section, and the paths showed 2010 instead of 2009. But we just replaced the two instances of 2010 with 2008 and it worked. Hurray!
August 14, 2010 at 10:50 pm
Hi Jenn,
Glad my post helped 🙂
Cheers,
Uzzie
February 26, 2011 at 9:11 pm
Hi Jenn,
Glad my post helps. And sorry for late reply 🙂
Cheers,
Uzzie
November 10, 2010 at 5:44 pm
Same here saved a lot of my time! 🙂
I just had to do additional modifications, I need to delete also the block for tags . PageName is not yet supported by 2010.
February 26, 2011 at 9:10 pm
Hi Danilo,
Glad my post helps.
Cheers,
Uzzie
January 23, 2011 at 8:15 am
Hi,
I have another problem and hope you can please help me.
I have SQL2008R2 and create the reports with VS2008shell. The reports code shows in the beginning:
You can see, that the table control is a ‘tablix’…
I try to use the reports in VS2010Express and installed the reportviewer 2008 SP1. But the reports don’t open in the recordviewer control because of this ‘namespace error.
What to do?
Regards-
Dietrich
February 26, 2011 at 9:07 pm
Hi Dietrich,
Sorry for late reply. I was so busy since earlier this week due my new project.
I think if you have created a report with SSRS R2 and tried to view it with Report Viewer 2008 SP1, it would give you an error. If you don’t mind email me your report and I’ll try to see how to convert it back to 2008 version or try to open it with VS2010.
Cheers,
Uzzie
February 8, 2011 at 7:23 pm
U saved my life and time !
THX !!!
February 25, 2011 at 12:15 am
Any success going from 2008 to 2005?
February 26, 2011 at 9:09 pm
G’Day Bill,
I haven’t got a chance to try to convert it back to 2005. But I would imagine it would be complicated as so many object change from 2005 to 2008. Unless in your report, you didn’t use any 2008’s features.
If you didn’t , would you mind to send me your report and I’ll what I can do.
Cheers,
Uzzie
April 11, 2011 at 10:46 pm
Thanks finally a solution that WORKS!!
Great POST Great HELP..
Cheers!
June 24, 2011 at 6:13 am
Thanks a lot Uzzie!!!!
I have some questions:
It worked for me when I delete ReportSection and PageHeader. Is there a way where I can put PageHeader again after converting from 2008 R2 to 2008?
Thanks again!!!
July 21, 2011 at 8:27 pm
It’s been very helpful 🙂
August 22, 2011 at 4:25 pm
Saved one more person’s day here:) thanks Mate!
March 31, 2012 at 4:03 am
wonderfuly!!!!
August 1, 2012 at 10:40 pm
There’s another one: when having the Datasource embedded in the report and using Windows/Integrated security, 2008R2 has “Integrated” whereas 2008 has “Windows” as a value!
August 16, 2012 at 4:05 am
Thank you for posting this finding, it saved my day too! Nelly
September 21, 2012 at 2:21 pm
excellent – helped us a lot. The vendor came with SQL2008 R2 reports, while we have SQL2008 – vendor was here only for the day & business wanted to see the reports urgently. This fix saved us big time, thanks a lot