Report Builder 2.0 - Dataset Based on Excel File

Create a Dataset based on the data in the Excel file

Data that gets displayed in a report is obtained from a dataset. In this section you will see how you get a dataset by using a query.

1. Click on the Next button in the New Table or Matrix window.

2. The Design a query page of the New Table or Matrix wizard is displayed.

3. Type in the following statement and hit on the (!)[Query run] button. Select * from [Sheet1$]

The query is executed and the result is displayed as shown:

Design a report to display the data

Once the dataset is available then the report can be laid out to display this data. Again you will follow the wizard to fashion the report to display the data.

1. Click on the Next button.

The Arrange fields page of the New Table or Matrix wizard gets displayed.

2. Click on Time and drop it on the Values field and drop each of First, Second_, (an underscore is appended to Second as it would represent a system variable otherwise) and the Third on the Row groups as shown:

3. Click on the Next button to display the Choose the layout page of the wizard.

4. Click on the Next button on the Choose the layout page.

5. Choose a style (herein Mahogany) on the Choose a style page and click on the Finish button.

The report design gets displayed in the design surface of Report Builder as shown:

6. Run the report from Home | Run (F5).

The report is displayed as shown in the following figure: