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) / Make dynamic report pa...
Microsoft Dynamics AX (Archived)

Make dynamic report parameter blank and hide dynamic filter

(0) ShareShare
ReportReport
Posted on by Bintang 563

Dear Experts,

I'm developer customize and report Dynamic AX 2012 R3

Now I create a report from my own table

I created report with SSRS Visual Studio Report Model, created Dynamic Parameter but can't set to Blank / Empty

Here is my parameter form

3872.Report-Parameter-3.png

I want to create a Dynamic Parameter like a lookup, image below :

6505.Report-Parameter-2.png

The question is how to create Dynamic Parameter like a lookup and how to hide Select Button at the bottom?

Any suggestion or reference for me?

Thank you, best regards

Bintang

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,965 Most Valuable Professional on at

    You said you can't set Dynamic Parameter empty/blank, but it's not clear why. What's the problem?

    When you say "to create Dynamic Parameter like a lookup", do you mean that you want to set the range for Vendor account field to value selected in your parameter.

    If you want to hide the Select button, do you want to keep the query in background, or is your intention to completely get rid of the query? Note that using a query is much more powerful, because users can set ranges for other fields, use wildcards and so on. I would be careful about hiding it from users, because the report will become less useful.

  • Bintang Profile Picture
    Bintang 563 on at

    Dear Martin Dráb and Crispin John Augustine,

    Thanks for your advise

    I forgot what I did yesterday, maybe I change property value on parameter form at Visual Studio and change on query range I guess, It work like I want now

    Thank you very much

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