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) / Run SSRS Report from R...
Microsoft Dynamics AX (Archived)

Run SSRS Report from Report Manager URL

(0) ShareShare
ReportReport
Posted on by AnkurBh 107

I developed an  Report with RDP class. I am passing query it to the report  as SRSReportQueryAttribute .

Report is working fine when we run from AX.

But when I run from Report Manager URL present in Report Server configuration is AX it doesn't prompt to enter values to query, it directly shows all the data. It doesn't ask the query parameters and ran the report showing all data.

IS this the way it should be or is any issue of alternate solution.

*This post is locked for comments

I have the same question (0)
  • Anoop Tripathi Profile Picture
    Anoop Tripathi 790 on at

    I believe this is because when you are access the Report Manager URL the report is run under the security account as defined for the connector which usually has admin level rights and hence rendering all records.

    Check out the architecture here:

    technet.microsoft.com/.../dd361996.aspx

  • Iulian Cordobin Profile Picture
    Iulian Cordobin 8,201 on at

    So, you want what parameters to be shown on the reports' run page?

    Is it the Query that you want to set some ranges on (option that was possible in AX before the report is displayed), or is it the other parameters that are present in the Contract and are basically dropdowns with some values, radio buttons, etc?

  • AnkurBh Profile Picture
    AnkurBh 107 on at

    I want to set some ranges on the query, there are no other parameters/contract class

  • Verified answer
    Iulian Cordobin Profile Picture
    Iulian Cordobin 8,201 on at

    I though you will say that, and, unfortunately (at least from my experience) this is not possible. The ranges you set on the query itself are embedded in the AX kernel handling classes and of course you can't access that from the SSRS Reports (manager) URL. So you are not able to do that.

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