15 September 2014

Before creating report with SQL Server Reporting, make sure that you have Business Intelligence Installed.
Then run SQL Server Business Intelligence Development Studio from start menu window:

Visual Studio 2005 users should recognize this environment. Business Intelligence is included in types of project in Visual Studio 2005.
Create a new project by clicking menu File--> New --> Project...
1. Choose Project Type: Business Intelligence Project.
2. Choose Report Server Project Wizard.
3. Give the project a name, e.g. Countries.
4. Check Create directory for solution check-box to create specific folder for the project solution .
5. Click OK button, a wizard will be prompted. Click Next to continue.
 6. Set datas ource name and click Edit button to set database connection.
7. Set database connection to database and server used.
8. Test using "Test Connection" button, then click OK when connection is success.
9. Dialog window will be back to Select Data Source, then click Next.
10. Insert SQL query to display report data.
11. Choose table report type, for now choose the default option (Tabular) then click Next.
 12. There will be dialog of table design, leave it default and click Next.
 13. On the next step we can choose table style. There are six optional style, click on its item list to see its preview design on the right side. Choose a style then click Next.
 14. Determine Server for deployment or let it default and click Next.
 15. Type report name and click Finish.
  16. A report design will be displayed, and can be customize as you want.
 17. To see the result click on preview tab.

Your first .rdl file can be deployed to Report Server.

Next: Creating report without wizard
 
Click here if you like this article.


Related Article:
  1. Installing Business Intelligence SQL Server 2005
  2. Creating Report with SQL Server Reporting (Wizard)
  3. Creating Report with SQL Server Reporting (without wizard) | Part 1
  4. Creating Report with SQL Server Reporting (without wizard) | Part 2
  5. Design Layout Report
  6. Creating Parameter for Filtering
  7. Stored Procedure as Report Data Source
  8. Parameter Data List from Database Query
  9. Creating Report Group
  10. Create Sequence Number Using RowNumber Function
  11. Uploading Report FIle (.rdl) to Report Server
  12. Remove Report Page Break/Page Break 
  13. Query to Generate Subscription List

0 comments: