web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,603

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
    3 on at
    RE: AX SSRS Subreport: "Error: Subreport could not be shown"

    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,603 on at
    RE: AX SSRS Subreport: "Error: Subreport could not be shown"

    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
    3 on at
    RE: AX SSRS Subreport: "Error: Subreport could not be shown"

    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,603 on at
    RE: AX SSRS Subreport: "Error: Subreport could not be shown"

    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
    3 on at
    RE: AX SSRS Subreport: "Error: Subreport could not be shown"

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans