Microsoft Dynamics NAV (Archived)

Report Parameters

(0) Share

Report

Posted on by SamCha

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

I have the same question (0)

All responses (15)

Answers (0)

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Create a global variable for your parameter and add them to the Request Page of your report. Then in OnPreReport trigger you can handle the value as you need.

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

I wanted to have it in the Parameters of the report, but I think we can't do that in NAV.

So I assigned the parameter to a header of my report dataset.

Was this reply helpful? Yes No
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

In NAV report parameters are handled in the request page if they must be set by the user that executed the report. This is the standard way. Maybe I’ve not understood your needs.

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

If you open a report in VisualStudio, you can see there are parameters there (usually you should see the Captions).

I was wondering how to add one there directly, but from what I understand we can't.

Was this reply helpful? Yes No
RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

Question is somehow confusing, Can you make it a level more clear please?

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

Here:

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

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

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

Hi SamCha,

Hope this video helps you:

www.youtube.com/watch

Was this reply helpful? Yes No