Report Project and Report Designer

Report Project and Report Designer

• feelingfoel

  I do not think this is possible. Reporting Services Developer simply uses the Visual Studio IDE its connection to other visual projects ends there.
  
  I'm not sure what you are trying to do here, but a report would be usless in another program since it requires the report server to run and cannot run alone.
  
  

• Lensouille

  Thanks for your reply!  I'm looking at your second option, the BI Development Studio only.  If VS 2005 is already present, does it mean it will install the BI designer components only  
  
  In any case, will it be fully functional as if SQL Server 2005 is installed   Say it contains SSRS, SSIS, SSAS, etc. 
  
  With this option, can I still deploy reports (to a report server instance outside of this environment I suppose)
  
  Thanks
  
  
  

• Ultrasoft

  I'm trying to do the same thing, but nothing in this thread helps. The post that is marked as the solution just links to help about the reportviewer control. This is great for viewing reports that are already created. I want to be able to launch the report designer programmatically and then save or deploy the reports created there. Has this problem been solved
  

• RonaldoRoma

  These are the options:
  
  * VS 2005 by itself contains a report designer that allows you to design RDLC files (i.e. reports used by the report controls in "local" mode without report server).
  
  * SQL Server 2005 Setup has an option to install "BI Development Studio" only. If VS 2005 is not yet present on the target machine, it will install just the VS 2005 shell and the BI designer components you choose in setup.
  The report designer in BI Development Studio is very similar to the report designer from RS 2000.
  
  
  -- Robert
  

  
  
  

• EkiA

  Yes, it's an end-user designer. I've seen report builder but that can only be used with data source models, and we're writing our own data extension. Basically we'll have to create a basic RDL file and then let the user edit that on their own with designer.
  
  

• Dariya

  No actually we want to use the Report Server. 
  
  My question is whether we could programmatically launch Report Designer   We used to be able to do that with Crystal Reports Designer.
  
  
  Thanks
  
  
  

• Sebastian Morsony

  If VS 2005 is already present, running SQL Server 2005 setup and selecting BI Development Studio (including subcomponents such as report designer) will install fully functional designer components.

  Yes, with report designer in BI Development Studio you can deploy to any Report Server 2005 (by specifying the TargetServerUrl property in the Report Solution properties).

  -- Robert

  
  
  

• Jeremy Lew

  Similar to my original question, do we have to install SQL Server 2005 in order to design reports to be deployed to report server  
  
  That is, for a business analyst to create reports, SQL Server 2005 must be installed in the same environment.  I don't think installing Visual Studio .NET 2005 alone is enough, correct
  
  Thanks!
  
  

• xelax

  Actually, this is now possible using the Report Controls built into Visual Studio 2005. You can run reports with our without a report server. See http://whidbey.msdn.microsoft.com/library/ url=/library/en-us/rs_vsrpts/html/0334cfba-2cb7-4d8b-8927-e08b888450cd.asp frame=true for the Beta 2 docs.
  
  

• pmccombs

  The VS 2005 Report Viewer controls include a report designer integrated into the VS environment that can be used at design/development time.

  Are you looking for an end-user report designer Out of the box, the closest you can get at this point is ReportBuilder (available with SQL Server 2005 Reporting Services - see e.g. http://www.microsoft.com/sql/2005/bi/BIn_Ad-HocReporting500k.wvx). There are ISVs who offer e.g. web-based end-user report design tools which generate RDL reports (see http://www.microsoft.com/sql/reporting/partners/default.asp).

  -- Robert

  
  
  
• Report Project and Report Designer