Create SSRS report by using view

Finance and Operations/AX Developer Forum
1

Hi,

I am using AX 2012 R3, Visual Studio 2013. I have created view in AX. I want to create SSRS report based on this view. How to do it?

2

First create a query using your view as datasource. Then you can create query based SSRS report. Please refer this link for step by step guide https://community.dynamics.com/ax/b/alirazatechblog/archive/2015/07/04/query-based-ssrs-report-from-scratch-dynamics-ax-2012-r

3

Thanks ! for your reply. I have followed step by step by it’s giving error - Report design RMSCoinJournalDifferences.RMSCoinJournalDiffDesign not found in AOT.

4

Done !

5

My report done! Now I want to do grouping on date field and sum of value should be display for date grouping. How to do it?

6

Adding Grouping and Totals

https://youtu.be/keBOCdMfelU

Hope this helps you to achieve what you want.