Sub Reports within AX SSRS Reports
Views (1888)
So while trying to add a subreport (no parms) to an existing report I discovered some goofy things that need to be followed in order for a sub report to work within AX.
1. Put both reports within the same project (model project within Visual studio)
2. Right Click on the sub report and choose properties. You have to manually type in the report name you want to use instead of being given a dropdown like normal SSRS
3. Include the design name (ReportName.Report, ReportName.PrecisionDesign1, etc...) within the report name mentioned in step 2.
4. Deploy the report to the same folder on the SSRS server (you may need to "move" your report into StaticReports> language> folder)
5. Previewing of subreports does not work within visual studio for AX sub reports. Once you follow steps 1-4 you should be able to add the model to the AOS. Then deploy your modified report and the subreport should show up correctly whenever you call the report from AX.
I sure do hope microsoft has some big enhancements for SSRS in 2015.
1. Put both reports within the same project (model project within Visual studio)
2. Right Click on the sub report and choose properties. You have to manually type in the report name you want to use instead of being given a dropdown like normal SSRS
3. Include the design name (ReportName.Report, ReportName.PrecisionDesign1, etc...) within the report name mentioned in step 2.
4. Deploy the report to the same folder on the SSRS server (you may need to "move" your report into StaticReports> language> folder)
5. Previewing of subreports does not work within visual studio for AX sub reports. Once you follow steps 1-4 you should be able to add the model to the AOS. Then deploy your modified report and the subreport should show up correctly whenever you call the report from AX.
I sure do hope microsoft has some big enhancements for SSRS in 2015.
This was originally posted here.

Like
Report
*This post is locked for comments