Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Report

(0) ShareShare
ReportReport
Posted on by 3,099

Hi

  In a report I have Dimension Value . In filter Code appears as TextBox . I want that user should get List for selection . 

2844.Untitled.png

Thanks

*This post is locked for comments

  • Suggested answer
    4BzSoftware Profile Picture
    6,073 on at
    RE: Report

    Hi jsshivalik,

    Yes, it is necessary to define variable for report. It is impossible to show list of Dimension Value when user performs filter on Dimension Value table itself. Something likes filtering Customer No. on Customer List (text box) and filtering Sell-to Customer No. on Sales Order (list box).

  • jsshivalik Profile Picture
    3,099 on at
    RE: Report

    Hi

      Is it necessary to define variable. Isn't it possible that when user Select Dimension Value Filter Code , there list should appear

    Thanks

  • Suggested answer
    4BzSoftware Profile Picture
    6,073 on at
    RE: Report

    Hi jsshivalik,

    You should use TableRelation property to show list for selection.

    Define a Code20 variable with TableRelation property to "Dimension Value" ... in Request Page of Report:

    request-page-6_2D00_26_2D00_2018-10_2D00_25_2D00_07-PM.png

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans