Create SSRS report by using view


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?

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

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

Done !

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?

Adding Grouping and Totals

Hope this helps you to achieve what you want.