Report Designer Setup

We have a data warehouse setup with SQL Server 2005 Reporting Services.  The Data Sources, Data Source Views, and the Report Models have been built.  Report Builder is functioning.  I need to be able to create reports with Visual Studio 2005 using Report Designer.  I already have Visual Studio 2005 on my workstation but can not figure out how to get Report Designer to show up when I try to create a new report.  What am I missing and how do I get it?
baiedwAsked:
Who is Participating?
 
brejkConnect With a Mentor Commented:
You need SQL Server 2005 (not Express Edition) installation files (CD/DVD/...).
0
 
brejkCommented:
Report Designer is an integral part of Visual Studio 2005. To use Report Designer you have to create a Report Server or Report Server Project in Visual Studio (Report Server Project template is one of Business Intelligence Projects in New Project window) and add at least one report to this project.
0
 
brejkCommented:
Maybe I was not as clear as I should be. You work with Report Designer __USING VISUAL STUDIO__ and only in design time.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
baiedwAuthor Commented:
I want to be able to create reports in VS 2005 using Report Designer and publish the reports to the data warehouse.
0
 
baiedwAuthor Commented:
The icons to create a Report Server Project does not show up.  That is what I am missing.  How do I get them to show up?
0
 
brejkCommented:
"Publish the reports to data warehouse"? You mean you want to create some reports _BASED ON DATA FROM DATA WAREHOUSE_? You have to create a Report Server Project, then create a report, add a dataset (-s) which can contain some queries to your data warehouse and then play with layout and finally deploy the reports to the Report Server. All can be done from Visual Studio 2005.
0
 
brejkCommented:
You have to install Business Intelligence Development Studio (it's a component of SQL Server 2005 installation) on a machine on which you want to develop your reports. This will add additional project templates to Visual Studio 2005 and you will be able to create a Report Server Project with Visual Studio.
0
 
baiedwAuthor Commented:
Is that something I can download or do I need the CD's?
0
All Courses

From novice to tech pro — start learning today.