web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

Sub Reports within AX SSRS Reports

adam260 Profile Picture adam260 1,871
​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.

This was originally posted here.

Comments

*This post is locked for comments