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) / 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

I have the same question (0)
  • Verified answer
    Dennis Huesmann Profile Picture
    Dennis Huesmann on at

    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

  • Greg's Mom Profile Picture
    Greg's Mom on at

    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!

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