Create a New Report in Visual Studio

1. Open Microsoft Visual Studio.

2. If Visual Studio is run for the first time, select General Development Settings for the default environment setting and click Start Visual Studio.

3. On the File menu, point to New, and then click Project. The New Project dialog box is displayed.

4. In the Installed Templates pane, click the Microsoft Dynamics AX node, and in the Templates pane, click Report Model.

5. In the Name box type SSRSDemo, and in the Location box, type a file path.

6. Click OK.

7. In Solution Explorer, select the SSRSDemo project, right-click, select Add and click Report.

8. An empty report model named Report1 is created.

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

10. Type "CustTransList_WS1" as the name.

11. Expand the CustTransList_WS1 node if it is not already expanded.

12. Right-click the Datasets node and then click Add Dataset.

13. Select the node for the dataset. 

14. In the Properties window, specify the following properties.

o Data Source: Dynamics AX

o Data Source Type: Query

o Name: CustTransListDS

o Query: Select * from CustTrans_W1 (or use the ellipsis button to use the wizard to select the query and choose the desired fields to display). 



15. In Model Editor, select the CustTransListDS node and drag it onto the Designs node. An auto design named AutoDesign1 is created for the report. 

Best Regards,
Hossein Karimi