Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

url and ssrs report

Posted on by 345

HI All,

I am looking for dynamics URL creation on SSRS report. 

Idea is, to open a new dynamics AX form in new tab on a row column and passed column parameter to open the new form.

In my new form will open records based on passed parameter.

any suggestion.

Thanks

Neetu

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: url and ssrs report

    Hello Neetu,

    Not sure if this cross company drill through can be achieved with standard tools.

    An alternative would be leveraging SSAS and incorporating it into your SSRS report.

    Maybe that is a way forward?!

    Best regards,

    Ludwig

  • Neetu Chamling Profile Picture
    Neetu Chamling 345 on at
    RE: url and ssrs report

    HI Ludwig,

    Drill though option works well for me too but only if target form has to open in same company context as executed report context.

    I have 2 columns on same row of ssrs report, on click of one column one form opens in company context c1 with parameter v1

    and on click on 2nd column new form should open in company c2 with parameter v2.

    confirmed by Microsoft that drill though option works only with-in same company context .

    Hence I was trying to find alternative to open new form in new tab under c2 context .

    Thanks

    Neetu

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: url and ssrs report

    Hello Neetu,

    Do I understand you correctly that you basically want to add an 'external link', i.e. a menu item that opens a specific form filtered by a specific record from within your SSRS report?

    The drillthrough is actually made for this. Why does this not work for you?

    Best regards,

    Ludwig

  • Neetu Chamling Profile Picture
    Neetu Chamling 345 on at
    RE: url and ssrs report

    Sure Satish,

    Its SSRS report , and one columns in row. on clicking on column value a dynamics AX form should be open in new tab.

    I tried to open using Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink

    however this has limitation ( confirmed by Microsoft), it can open only in same tab and within same company context.

    I am looking for alternatives to open a form in new tab under another company context ( value in mentioned column)

    Thanks

    Neetu

  • Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: url and ssrs report

    Hi Neetu,

    I am not able to understand the questions here. Do you mind adding bit more detail to it please so someone can help answer this.

    Thanks,

    Satish Panwar

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans