SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Is SSRS RDL maintenance dependent on the version of BIDS that created it?


Is SSRS RDL maintenance dependent on the version of BIDS that created it?

Author
Message
Express12
Express12
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1454 Visits: 1058
I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an SSIS Pkg was developed in SQL 2005 BIDS, you must use SQL 2005 BIDS to maintain it. Optionally, you may convert/upgrade the SSIS Pkg to the version of SSDT or BIDS you have open.

Is the same true for SSRS RDL? If I have a report developed in SSRS BIDS 2005, (outside of converting it to SQL 2012) do I need to use BIDS 2005 to maintain it?

BT
happycat59
happycat59
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4735 Visits: 3215
Express12 (3/17/2014)
I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an SSIS Pkg was developed in SQL 2005 BIDS, you must use SQL 2005 BIDS to maintain it. Optionally, you may convert/upgrade the SSIS Pkg to the version of SSDT or BIDS you have open.

Is the same true for SSRS RDL? If I have a report developed in SSRS BIDS 2005, (outside of converting it to SQL 2012) do I need to use BIDS 2005 to maintain it?


As a general rule, yes - you probably do need to stick with the same version of BIDS to maintain your reports. If you open a report in a later version, the RDL will be upgraded and you probably will not be able to open it with an earlier version of BIDS. You could also have problem deploying the upgraded report to an earlier version of SSRS (not 100% sure of that but it is quite likely).



andrexcobar
andrexcobar
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 50
Express12 (3/17/2014)
I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an SSIS Pkg was developed in SQL 2005 BIDS, you must use SQL 2005 BIDS to maintain it. Optionally, you may convert/upgrade the SSIS Pkg to the version of SSDT or BIDS you have open.

Is the same true for SSRS RDL? If I have a report developed in SSRS BIDS 2005, (outside of converting it to SQL 2012) do I need to use BIDS 2005 to maintain it?



Yes, that is exactly true. You can upgrade your BIDS version to 2008, but you can't edit RDLs developed in SQL Server 2008 using BIDS 2005.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search