May 21, 2012 at 8:45 pm
I want to be able to open the report builder 3.0 files on the report server (sql server 2008 r2) using the bids environment located on my workstation. I prefer to use bids (visual studio.net 2008 for ssrs reports) since you can drag and drop items from the toolbox in visual studio onto the designer surface. I also would like to use the 'properties' for various SSRS objects since I think the way to access these properties is easier than using report builder.
Thus can you tell me how to open report builder 3.0 files that are located report server using bids (visual studio.net) on my workstation?
May 22, 2012 at 1:58 am
I dont believe you can, one thing I would say is get a copy of RSScriptor, download all the rdl files and dump them into a solution and store that solution in some source control environment, that way you can open the solution and modify deploy when needed within BIDS.
I would recommend always keeping your RDL files in source control incase of the worst happening to your SSRS server, RS database and encryption keys so you can redeploy them in the event of worst case.
May 22, 2012 at 2:00 am
wendy elizabeth (5/21/2012)
I want to be able to open the report builder 3.0 files on the report server (sql server 2008 r2) using the bids environment located on my workstation. I prefer to use bids (visual studio.net 2008 for ssrs reports) since you can drag and drop items from the toolbox in visual studio onto the designer surface. I also would like to use the 'properties' for various SSRS objects since I think the way to access these properties is easier than using report builder.Thus can you tell me how to open report builder 3.0 files that are located report server using bids (visual studio.net) on my workstation?
Unfortunately as BIDS is project based it cannot directly access individual report from the SSRS Reports site. You can choose to Add\Existing Report in project mode and this copies the RDL into the current project. The RDL I think needs to be downloaded to a disk (local or network) before it can be added. The issue is when you attempt to deploy as it deploys to the location specified in the report project properties not the original location.
As an additional comment I prefer to use Report Builder 3.0 as a default development environment for simple reports and BIDS when I need to produce corporate standard reports.
Fitz
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply