Deploy report from VS2003 to SQL Server 2008R2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Deploy report from VS2003 to SQL Server 2008R2

Author

Topic

Ciupaz
Posting Yak Master

232 Posts

Posted - 2013-10-04 : 09:35:43

Hi all
for several days I'm trying to restore the exact layout of a report,
especially in the export to Excel, after importing it in
BIDS 2008 from Visual Studio 2003, where it was originally created.
The point is that when it was in the 2003 version, the layout and export to
Excel corresponded exactly to what the users expected.
Now, however, after opening it in 2008 Business Intelligence (that deploy on
SQL Server 2008 R2), has all the layout changed, and also the resulting Excel file
is completely changed.
Does anyone know if is possible to deploy from VS2003 (original report) to
SQL Server 2008R2 directly, in order to keep the old layout?

Thank you

Luis

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-04 : 10:23:25

when you say VS 2003 was it embedded report(rdlc)?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Ciupaz
Posting Yak Master

232 Posts

Posted - 2013-10-04 : 10:26:45

It's Visual Studio .NET 2003 Enterprise Architect with Business Intelligence Project available.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-07 : 06:02:22

quote:
Originally posted by Ciupaz

It's Visual Studio .NET 2003 Enterprise Architect with Business Intelligence Project available.

so you chose report server project and created report in it?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Ciupaz
Posting Yak Master

232 Posts

Posted - 2013-10-07 : 06:24:48

Yes, I've copied (Add Existing Item) old reports (from VS 2003) into Business Intelligence Development Studio 2008.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-07 : 07:06:41

quote:
Originally posted by Ciupaz

Yes, I've copied (Add Existing Item) old reports (from VS 2003) into Business Intelligence Development Studio 2008.

so I guess then problem might be while migrating reports to 2008 format.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources