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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)
Unanswered

AX SSRS Subreport: "Error: Subreport could not be shown"

(0) ShareShare
ReportReport
Posted on by 6,611

Hi,

I have a subreport built using a data provider class. At the moment, it has a single parameter passed to render the report. It works fine if I call the report directly with a param value. The subreport is nothing but a matrix control. 

I've tried adding this subreport to a main report which also is based on a set of data provider / contract classes. As I'm still testing, I've quickly thrown together a temp table containing a single record with only 3 columns. Running this main report without the embedded subreport control, the data for the main report renders without issue. I've tried adding the subreport control to the main report, specified the subreport properties with the single parameter value hardcoded as an expression, deployed the reports, and its failed upon running in AX. Both reports are in the same project in VS. I've read forum posts, tutorials, etc for any information on what I may have missed but everything looks OK far as I can tell.

My question, are there any known issues with subreports in AX. For instance, one post I read said that RDP reports do not work with subreports, but other readings I've seen directly challenge it. Are there best-practice methods in testing the subreport is detectable from the main report? 

Thank you.

*This post is locked for comments

I have the same question (0)
  • Hariharans87 Profile Picture
    36 on at

    The sub report will work in AX SSRS. The only thing is that you need to pass all values to sub report parameters like company and other.

  • bankk Profile Picture
    6,611 on at

    Hi Hariharan,

    I'm pretty sure I was passing the correct parameter and value. There was only a single parameter in my testing. Well, what ended up happening was I deleted my subreport and pointed the main report to a separate report which I created a few days ago which was very similar in format. This time the subreport rendered in the main report body as anticipated. I'm still not quite sure what was wrong with the original subreport but I've at least managed to get over this bump for the time being.

    I appreciate your comment and suggestion.

  • Hariharans87 Profile Picture
    36 on at

    Don't delete the standard parameter like company, partition key, rendering culture, etc. from the sub report.

    You need to pass the value to all sub report parameters in the main report.

    Try to run the sub report directly in the report manager URL or see the preview in Visual Studio to make sure that sub report is working fine.

  • bankk Profile Picture
    6,611 on at

    I didn't delete the details from the subreport, I deleted the entire report. Also, I did try running it from the report manager via the URL and it also failed with the old subreport. The initial, rough report appears to be running now but there's still much to do. Thank you.

  • Hariharans87 Profile Picture
    36 on at

    We use sub report in AX SSRS. Both reports should be under one AX SSRS report project.

    Create two reports one is parent report and another one is child report.

    So, both report parameters will be created automatically.

    Try to run the both reports and make sure that both reports are running correctly.

    Add the sub report control in the parent report and pass the value to the parameters in the action tab in the control properties.

    I am not sure that it is sub report control or textbox control.

    The above things will work for sub report concept.

    You may refer the subreport chapter in the AX 2012 reporting cookbook.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Basit Profile Picture

Basit 1

#1
GL-01081504-0 Profile Picture

GL-01081504-0 1

#1
Roya Profile Picture

Roya 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans