Quick one: SSRS – upgrading Vision from version 6 to 7

Today a customer called me and said:

“We converted to Vision 7 and now the custom invoice you created for us is not showing”.

Solution: If the report files are missing for your custom reports, you will need to re-load them.  But first you must:

1. make sure you have BIDS 2008 installed

2. open every single .rdl file in BIDS 2008 and close it again (meaning the .rdl files you are interested in loading, meaning your custom reports or invoices)

3. when you close each file, BIDS should prompt you to save them

4. re-load your reports in 7 as you would normally.

This is assuming you have your own back ups of these files in case something goes wrong.

What it does:

It converts all your .rdl files into a more recent version of SSRS reports, most notably doing away with the <table> object and introducing the <tablix> object.

Cheers!

Comments or questions for Loren?

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