Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Displaying Dynamics Pa...
Microsoft Dynamics AX (Archived)

Displaying Dynamics Parameter Values on SSRS Reports

(0) ShareShare
ReportReport
Posted on by Greg's Mom

Hello,

Is it possible to display the values of dynamic parameters on SSRS reports?  I have an SSRS report with 5 parameters coming from ranges on my report's query.  On the SSRS side, these parameters are summarized into a single parameter with a name like MyDataSet_DynamicParameter.  I've tried adding an expression on the report header: =Parameters!MyDataSet_DynamicParameter.Value but that does not display the parameter values.  Does anyone know how to get the individual parameter values out of the dynamic parameter so I can display them individually it on my report header? 

*This post is locked for comments

  • Greg's Mom Profile Picture
    Greg's Mom on at
    RE: Displaying Dynamics Parameter Values on SSRS Reports

    Hi Dennis,

    Thank you for your reply.  I believe you are correct that the only approach would be to create unbound parameters on the SSRS report to display those values.  Then on the AX side we'll need a custom data contract.  We can grab those values and pass them to the data contract by creating a custom controller class.  I was hoping to avoid all that as 99% of the functionality is taken care of by my query and report.  

    If anyone has a simpler alternative, I would still love to hear it!

  • Verified answer
    Dennis Huesmann Profile Picture
    Dennis Huesmann on at
    RE: Displaying Dynamics Parameter Values on SSRS Reports

    Hi,

    I don't think the report server is able to create a meaningful representation of an AX query. If you are using a data provider class you could retrieve your query from the data contract and create a string from all ranges and filters on the query. You could then write that string to a new field on you temporary table and print it on the report.

    Best regards

    Dennis

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans