Few weeks ago, I was developing an interesting report in SSRS which pulls out data from AX - Projects module.
It was interesting for 2 reasons:
1. I learned to use more effectively SQL Server CTE's (Common table expressions) while developing this report.
From a layman's perspective, CTEs were introduced since SQL Server 2005 and it’s more useful to do a recursive search (display hierarchical data e.g. employee-manager, BOM etc). In my scenario, I had to do a recursive search for Project-Parent Id in my Stored proc)