I have been using SSRS for a few years. Now I want to create a report using Visual Studio 2008 Reporting Tools for Microsoft Dynamics AX 2009. I know very little about AX 2009. I just want to create a simple dataset with a sql statement like I did with SSRS. Can this be done? It seems like they want me to use a datamethod or something which involves creating a method in VB or C# that returns a datatable. Is this the only way to build a dataset or can I use a sql statement?
In my Experience Ax reporting tools in VS 2008 was a very flexible to create reports...
not only u can use datamethods..
you can get your query from ax to VS 2008 reporting tool
yes you can write sql statement...shared datasource...
goto youtube there is one series of videos (43 videos) explaining VS 2008 Reporting tools.. (Dynamics AX 2009 and SSRS part 1...43)