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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 : SSRS SubRepo...
Microsoft Dynamics AX (Archived)

AX 2012 : SSRS SubReport usage

(0) ShareShare
ReportReport
Posted on by Community Member

Hi, I need to use SubReport in SSRS 2012. I tried to add subreport. However,  I have no dropdown in the "Use this report as a subreport:"-field, and whatever i enter there manually is not accepted.

Error message: "The report definition for report '{Reportname}' has not been specified"

I tried  ProjectName.ReportName.PrecisionDesign1. However, when executed it says subreport is not published or the path is incorrect. Though the report is already published.

Has anyone successfully used subreports in AX 2012. Please let me know.

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Syed, have you find any solution jet? I have the same issue...

  • Stefan Quinn Profile Picture
    Stefan Quinn 80 on at

    Ok

    Round of applause for how badly SSRS is implemented in AX 2012.  What is a robust and easy to use product is stupidly complex in AX!

    My advice is to only use AX SSRS if you absolutely have to, otherwise just use regular SSRS.

    Anyway, the only way I could get sub reports to work in AX SSRS is to do the following:

    1.      Your sub report must be in the same visual studio project as your main report. 

    2.      Create your sub report control and link to the sub report. In REAL SSRS in the sub report properties box, the sub report is then in a drop down list.  Not so in AX SSRS.  You have to type in the report name with the .design, e.g. mySubReport.PrecisionDesign1

    3.      Manually add your parameters to pass them from the parent to the sub report.  Again REAL SSRS used drop down boxes, but AX SSRS, you guessed it, you have to type them in.

    I tried for hours to use a sub report that got its data from a query that had a range, in the hope that I could pass the parent report parameter to use this range.  The parameter shows up as a dynamicParameter, but alas couldn’t get it to work.

    The only way I could get this all to work was to use a report data provider for the sub report, and in AX have a data contract for the parameter for this data provider

    See below for my contract code

    [

        DataContractAttribute

    ]

    class SAB_ConsRptJobCardContract

    {

        ProjId  projID;

    }

    [

        DataMemberAttribute('ProjID')

    ]

    public ProjId paramProjID(ProjId _projID = projID)

    {

        projID = _projID;

        return projID;

    }

     

     

     

  • aaa510 Profile Picture
    aaa510 400 on at

    Hi Stefan,

    Can you share you project(xpo)? I would like to learn subreport.btw which version of AX? 2012?

    Thanks in advance!

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I think you can achieve the subreport concept through Report Drill through actions. Check out this link here

    msdn.microsoft.com/.../cc639019.aspx

  • Community Member Profile Picture
    Community Member on at

    Hello everyone, I tried this but in Visual Studio it did not work, but running the report inside AX, it worked.

    Sad but it's true.

  • Community Member Profile Picture
    Community Member on at

    i didnt get it ..ny1 plz guide me

  • Suggested answer
    Esther Mulijono Profile Picture
    Esther Mulijono 435 on at

    For further reference, try this link for subreport without parameters in AX 2012: axcalated.blogspot.com/.../sub-reports-within-ax-ssrs-reports.html

    --

    Regards,

    Esther

  • Community Member Profile Picture
    Community Member on at

    @Kamalakannan Elangovan : with   the help of drill through ...the sub report is generated in another window . but I want that sub report should get generated on same window . (just like the concept of factboxes in forms .....)

    thanks..

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans