SQL 2008


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.

Advertisements

Just came across the new SQL Server 2008 features pack. Download it here.
Also there is a new version of OLAP Extension for Excel 2007 just been released on 15th October. You can downloaded from Codeplex.
This new version contains cube search function that search field list and dimension data.

Cheers,

Uzzie