Monday, July 16, 2018

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

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...