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)

SamCha 18 on at

Like (0)

Report

RE: Report Parameters

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

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

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

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.

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

Like (0)

Report

RE: Report Parameters

Hi SamCha,

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

https://www.youtube.com

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

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).

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

Like (0)

Report

RE: Report Parameters

Hi SamCha,

Hope this video helps you:

www.youtube.com/watch

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Parameters

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

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
SamCha 18 on at

Like (0)

Report

RE: Report Parameters

Here:

Was this reply helpful? Yes No