How to create a Report Server Project in SQL 2005

**Shreevats** · 22-03-2010

Hi,
I am new in SQL and just for practice purpose on my computer I am trying to create a report server. For this first I just want to create a sample report server project in the system. What are the different steps involved in this. How to create a report server project and then how to generate the same live for different database integration. I need entire steps for this.

**Raine** · 22-03-2010

Launch Visual Studio 2005 or SQL Server Business Intelligence Development Studio. Go to File> New Project>> Report Server Project. Report Server Project Wizard can be used in the construction of simple and concise report. You can also create report templates with Report Model Project. A draft Report Server Project is composed of different files, they are Data source, different views of the data source and both of report you want to edit.

**Sam.D** · 22-03-2010

In the draft project the tab Data contains a list of different views of the data source. Each view is stored in a DataSet. The tab Layout contains the workspace that lets you customize your reports. And the tab Preview allows you to have a view before publication. So here you can see the different options in creating a project in report server. You can go through the help options.

**ZeDaX** · 22-03-2010

After a report server project work you will haev to create a Data Source. You must first time, connect your future reports to a data source. In the directory Shared Data Sources, please right click Add New Data Source. In the dialog that just opened, click on Edit and configure the connection to your data source. SSRS allows you to login as a relational database like SQL Server as a database as multidimensional OLAP cubes.

**ThoMas321** · 22-03-2010

Here in a project you can add as many reports as you wish. For that you can follow this step. Add a report by clicking on the Reports > Add a new report. Then the dialog Report Wizard is launched. In the first step you have the choice of selecting one of your sources of data or a new set. In the next step, the query builder appears. The Wizard allows you to choose between types of reports.

**Macarenas** · 22-03-2010

There is usually 2 type of report under the query builder wizard. The first is Matrix Report, it is the report matrix helps to highlight the multidimensional data. Each row and column will expand to display the data reports. Here you can see different tabs under it where under the the Page button, all th elements are contained in the header of the page.