Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Report Parameters
Microsoft Dynamics NAV (Archived)

Report Parameters

(0) ShareShare
ReportReport
Posted on by SamCha 2

Hi,

I trying to get a global variable to appear as a parameter in the report, which I am editing using Visual Studio.

As of now I have only seen Captions in the parameters, so I am wondering how to add normal parameters.

*This post is locked for comments

  • SamCha Profile Picture
    SamCha 2 on at
    RE: Report Parameters

    So if anyone wants more information, I am trying to use a parameter in the report to update the language code:

    8182.Capture.PNG

    I must use a parameter, otherwise if I use a Dataset field, I get this error:

    A value expression used for the report parameter 'Language' refers to a field. Fields cannot be used in report parameter expression

  • SamCha Profile Picture
    SamCha 2 on at
    RE: Report Parameters

    Oops after some testing, it doesn't work, because I can't change the value (or haven't found a way) of the automatic caption.

    It uses the field's caption and I can't seem to be able to change it from C/AL.

  • SamCha Profile Picture
    SamCha 2 on at
    RE: Report Parameters

    I did not see he had multiple videos.

    One thing that I saw that may work, is that when you use the "IncludeCaptions" property on a datafield, the captions are actually added as Parameters in the report.

  • 4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Report Parameters

    Hi SamCha,

    His video series is very nice, day 3 video may solves your case.

    https://www.youtube.com

  • SamCha Profile Picture
    SamCha 2 on at
    RE: Report Parameters

    Thank you for the hint, but he never uses any parameter in his video (you can see the parameters sub-node has nothing in it).

  • 4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Report Parameters

    Hi SamCha,

    Hope this video helps you:

    www.youtube.com/watch

  • SamCha Profile Picture
    SamCha 2 on at
    RE: Report Parameters

    I can't add them as fields, I get this error otherwise:

    A value expression used for the report parameter 'Language' refers to a field. Fields cannot be used in report parameter expression

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report Parameters

    I think you should add fields for Dataitem for ReqFilterFields properties.

  • SamCha Profile Picture
    SamCha 2 on at
    RE: Report Parameters

    I came with this problem again.

    I want to use the LanguageCode of the SalesHeader and put it into the Language of the report.

    However, if the data is in the dataset, we can't use it in the Language field, only parameters are allowed.

    How do I add a parameter to the report so that I can use it in the Language field of the global properties of the RDLC report.

    The parameters that are in the RequestForm do not appear in the report, or maybe I am missing a property to make them appear?

  • SamCha Profile Picture
    SamCha 2 on at
    RE: Report Parameters

    Here:

    3632.Sans-titre.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

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans