Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Chart type based on parameters

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi , 

I have ssrs report and i need to make dynamic chart type  in the design by drop down list parameter 

User can choose type of chart and chart type change depend on parameter 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Chart type based on parameters

    I need to Make one chart and make drop down list to change this type from line to pie to column and so on

  • Suggested answer
    Srini Ramidi Profile Picture
    Srini Ramidi 2 on at
    RE: Chart type based on parameters

    Hello,

    There are couple of ways you can achieve this, the easy option would be adding all the possible chart types  to SSRS report and  based on the parameter value you need toggle the chart visibility.

    Best,

    Srini

  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Chart type based on parameters

    Can't you use different report designs for the different charts? Then you could drive what design to show based on a report parameter selection by dynamically redirecting the user to the design relevant for that chart selection in preRunModifyContract as explained here:

    [View:https://community.dynamics.com/ax/f/33/t/108075:750:50]

    Here is some code example where they have implemented this elsewhere, on the Main method:

    https://community.dynamics.com/ax/b/dynamics101trainingcenterax/archive/2014/01/30/using-controller-class-in-developing-ssrs-reports-in-microsoft-dynamics-ax-2012

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans