Bind a Report to a Report Data Provider Class

1. In Solution Explorer, right-click the SampleRDPReport node, point to Add and then click Report.

2. In Model Editor, right-click the Report1 node, and then click Rename.

3. Type "CustomerReport" as the name.

4. Right-click the Datasets node, and then click Add Dataset.

5. In the Properties window, specify the following values.

o Data Source: Dynamics AX

o Data Source Type: Report Data Provider

o Default Layout: Table

o Name: Customer

o Dynamic Filters: True

This setting is for dynamic parameters on the report. Setting the property to True allows you to filter the report by setting a range on any fields from the data source table.

6. For the Query property, click the ellipsis button (…). A dialog box displays where you can select an RDP class that is defined in the AOT and identify the fields that you want to use. Select theSrsRDPSampleClass class and click Next. In the Select Fields dialog box, keep all the check boxes selected, and then click OK.

7. In Model Editor, select the Customer node and drag it onto the Designs node. An auto design named AutoDesign1 is created for the report. Based on what you select, the Query property value is
updated. In this case, the query is SELECT * FROM SrsRDPSampleClass.TmpCust. 

Best Regards,
Hossein Karimi