Report Server Project Wizard is one type of report creation in SSRS. Report Server Project Wizard is having some default report templates, using those we can create report. This is smiler to Report server Project, but in the Report server Project we need to design report template.
- Open BIDS and select the "Report Server Project Wizard", give the solution name and required path. Click on New Project window "OK" button.
- 'Report Wizard' window will open. Click on "Next" button.
- In the Report Wizard, 'Select Data Source' page will open.
- 'Shared data sources' check box is disable, because right now i don't have any shared data sources.
- Name: We need to give required Data source name.
- Type: Select the server type, i am going to use 'Microsoft SQL Server'.
- Connection String: If we have connection string then we type or past it in the text box. If we don't have then we can create using "Edit" button.
- "Make this a shared data source": If we check this option, then that Data source we can use it in the other reports under same solution.
- Click on "Edit.." button. Then "Connection Properties" window will open.
- Give the server name, authentication and select the "Database name".
- Click on "Test Connection" button to make sure connection is good.
- Click on "OK" button.
- Click on "Next" button. Then "Design the Query" page will open.
- If you are familiar with queries you can write query, otherwise we can use "Query builder".
- Sample 'Employee table creation script with data'
- Click on "Next" button. Then "Select the Report Type" Page will open
- Select the required report type (Tabular or Matrix).
- Click on "Next" button. "Design the Table" window will open.
- Select the required column then "Page, Group and Details" buttons will enable.
- I am going to pass "Gender" into page level. Dept_ID Group level. Remaining columns into details level.
- Click on 'Next' button. "Choose the Table Layout" page will open. Select the required options.
- Click on 'Next' button. "Choose the Table Style" page will open. select the required Style.
- Click on 'Next' button then "Choose the Deployment Location" page will open.
- I am using default values.
- Click on "Next" button then "Completing the Wizard" page will open.
- Give the required report name.
- Click on "Finish" button.
- Report is ready.
- If you want to view the report result set, click on "Preview" (Highlighted in the above screenshot).
No comments:
Post a Comment