16 September 2014


Next step, we'll try to create report without wizard. (previous: using wizard).
Load SQL Server Business Inteligence Development Studio.


Choose Business Intelligence Project -> Report Server Project.
Name the project then click OK button.

An empty solution will be created. Add item report by right clicking on Solution Explorer -> Add -> New Item...

Choose Report, name it then click OK button.

Packaged with report, there are 3 tabs:
  • Data : for setting database connection and query of data source.
  • Layout: for design report layout.
  • Preview: For view result of report created.
First lets setting a new data set for report data. Click dropdown on Dataset choose to create a new data set.


A dialog form named Data Source will be displayed. Choose type of Microsoft  SQL Server, then click Edit button.

We can choose server name from dropdown combo or manually type it. Fill data login (username/password), set "Save my password" checked. Choose database name from dropdown combo or manually type it.
Use Test Connection button to check if connection succeed.


When a message prompt "Test connection succeeded", means connection succeed. Klik OK to save and close dialog of Connection Properties.

Back to  Data Source form dialog, click OK button.

1. A new data set will be added onlist.
2. Activate Generic Query Designer.
3. Choose Command type: Text
4. Type query to get data report
5. Click Run icon.

Oooops this article become too long (~_~;)
Will continue here: Creating Report with SQL Server Reporting (without wizard) | Part 2

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 
  14. Direct Printing to Printer

0 comments: