Skip to main content

Start the Business Intelligence Development Studio (BIDS)

Before you can use Business Intelligence Development Studio (BIDS) for our reporting service, you first have to set it up by creating a new report project.

Note: While there are several versions of SQL Server that can be used for connecting with Sigmafine SQL Access, we are using SQL Server 2008 R2 as a basis for our explanation of how to create a new report project.

To create a new project in BIDS:

  1. Ensure that you are logged into Windows as an Administrator.

  2. From the Windows Start button, run SQL Server Business Intelligence Development Studio.

    Microsoft Visual Studio opens.Figure 1171: Microsoft Visual Studio - Select New > Project

  3. From the File menu, select New > Project, to open the New Project window.Figure 1172: New Project window

  4. In the Project types list, select Business Intelligence Projects.

  5. In the Templates list, select Report Server Project.

  6. In the Name box, type a name for your new project.

  7. Click on the Location down-arrow and select the location for your new project, or click the Browse button to select it from a Find window.

  8. Click on the Solution down-arrow and select Create new Solution.

  9. Check the Create directory for solution checkbox.

  10. In the Solution Name box, type a name for the solution (it can be the same as the project name).

  11. Click OK to save your entries and close the New Project window.

    You are returned to the Microsoft Visual Studio window.

  12. In the Recent Projects pane, click on the report project you just created.

  13. If the "Solution Explorer" window is not visible, select View > Solution Explorer from the menu, as shown in Figure 1173.Figure 1173: Solution Explorer window

  14. In the Solution Explorer list, select Reports.

  15. Right-click on Reports and select Add > New Item to open the Add New Item window.Figure 1174: Add New Item window

  16. In the Templates list, select Report.

  17. (Optional) In the Name box, if you don't want to use the default, type a name for the report.

  18. Click the Add button to add your report and close the Add New Item window.

  19. If the Report Data window is not visible, select View > Report Data.Figure 1175: Open the Report Data window

For more information about the Report Data window, see Data Source, Data Sets and Connections.