Populating an SSRS report with data

Previewing the report at this point confirms only that it is configured to process correctly. But you still have not populated it with any data. To ensure that the report is properly populated with data at the time of report generation, you can check to verify that the data is being properly queried.

To verify that the SSRS report query is correct:

  1. In the Report Data panel, double-click the dataset you created earlier.
  2. In the Dataset Properties dialog box, click Query Designer.
  3. In the Query Designer dialog box, click the exclamation mark icon to query the data from the database.
  4. In the Define Query Parameters dialog box, if the Parameter Values column displays <Blank> for any or all parameters, change them to <Null>.
  5. Click OK.
  6. Verify that the query returned the expected data from the UserTask table.
  7. Click OK repeatedly to exit all dialog boxes.
    Note: If you have not yet created any user tasks, there is no data with which to populate this display. If this is the case, the query simply returns a single row containing the column headers. To see actual data displayed, first create some data using the Task List form and then run the query again.