Create a report using the Report Server Project Wizard

Create a report using the Report Server Project Wizard.

To create a report

1. Open Microsoft Visual Studio.

   

2. Select Create a new project.

   The Create a new project window appears.

   

3. In the Search field, enter Report.

4. Select Report Server Project Wizard.

5. Enter the name and location of your report in the Name and Location fields.

6. Select Create.

   The Report Wizard opens.

   

7. Select Next.

   The Select the Data Source page appears.

   

8. In the Select the Data Source page:

   1. Select New data source.

   2. Enter a name for the data source in the Name field.

   3. Enter the type of data source in the Type field.

   4. Select Edit.

   5. Select Change.

      The Change Data Source dialog box appears.

      

9. Select ODBC and select OK.

   The Connection Properties dialog box appears.

   

10. In the Connection Properties dialog box:

    6. Select Use user or system data source name.

    7. From the dropdown menu, select the ODBC connection to the desired system (for example, esrtdb).

    8. Select OK.

    The Connection Properties dialog box closes and the Select the Data Source page appears again, this time with the Connection string window populated.

    

11. Select Next.

12. If prompted for credentials, select Credentials and select Use Windows Authentication.

    The Design the Query page appears.

    

13. Select Query Builder.

    The Query Designer window opens.

    

14. In the Query Designer window:

    9. Enter the fields you want to query; for example, name, curval in the SELECT field.

    10. Enter the table you want to query; for example, analog in the FROM field.

    11. Select on the exclamation point (!) button.

    12. Select OK.

    The Query Designer window closes and the Design the Query page appears again with the Query string field populated.

    

15. Select Next.

    The Select the Report Type page appears.

    

16. Select Tabular and select Next.

    The Design the Table page appears.

    

17. Move the fields you specified in the Query Designer window to the Displayed fields list.

    

18. Select Next.

    The Completing the Wizard page appears.

    

19. Enter in a name for your report in the Report name field and select Finish.

20. The wizard closes and the report is now visible in Visual Studio.

    

21. Select Preview to view your report.