Upgrade to SQL Server 2008 fixes Reporting Services nested data region export to Excel


I recently upgraded to SQL Server 2008. The primary reason was to fix an issue with SQL Server Reporting Services – Excel Export issues with nested data regions.

“Any data region nested inside of a table or matrix data region is not supported. An error is displayed in Excel if this layout is encountered.”

They reportedly fixed this issue in SQL Server 2008. I my testing supports the claim and we no longer have the “nested data region errors”.

I must say that I was impressed with the new installer. Microsoft goes to great lengths to validate your SQL Server configuration before trying to upgrade. I had one upgrade issue that I talk about in this post, that was caused by me.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: