Extending Reporting Services - Professional SQL Server 2005 Reporting Services - page 579

After you have set both the type and connection string, you are ready to set up the basic data query. The
dataset that I used included a table called DimCustomer that I want to query. Enter Select * from
DimCustomer into the query window if you are using the sample provided or some statement that
works on your specific data. The query should resemble the text shown in Figure 13-9.
Figure 13-9
Simply finish the wizard by choosing your report style and the fields that you are interested in. I chose
the tabular report type. I then selected three fields and put them into the detail list. I chose the default
report style, and the resulting report is shown in Figure 13-10.
Figure 13-10
Next, you need to see if our extension actually returns data. Click on the Preview tab. The resulting data
should resemble Figure 13-11.