End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
· Other ERP Systems (like Oracle Peoplesoft) have utilised easy-to-use transctional report writers for the end-users for many years. I remember (many moons ago) using the DREAM-writer tools (Data Record Extraction and Management) within the One World sofwtare for end-user transactional and reporting analysis. It was a simple and easy tool for end-users and most impotantly it saved on ISV customisation time and money.
1.) Allow the user to select a query from the AOT (or a pre-determined list of allowed queries).
2.) Allow the users to set criteria on that query (to sub-select the data).
3.) Allow the user to determine any sort order for the results.
4.) Allow the user to select the fields required for report output.
5.) Allow the user to define any calculations or summarisations required.
6.) Execute the query and generate a .Net XML dataset.
7.) Combine the XML dataset with the RDL definition of a standard pre-defined report.
8.) Render the combined file within a local ReportViewer control (inside the Rich-Client).
The "Report Builder" product (distributed free with SQL Server) is a powerful and flexible report writer for "end-users" but you don't normally give direct access to the OLTP database to end-users in this fashion. If you did this then you would bypass the framework (and security). SSRS Report Builder is fine for the OLAP database (cubes) but it has bugs with date handling. For transactional reporting you must use Visual Studio for report development or a solution like the one that I'm proposing that allows end-users to re-use the queries within the AOT.
Interesting approach. What's your opinion on using SSRS' Report Builder?
Business Applications communities