Dynamically hide/display fields in Report request page - NAV 2009 R2

poppins · 2015-11-28

Hi everyone,

I have to create a report with two fields in a request page : a boolean and a text field.
One of the requirements is that the text field in invisible when I run the report, It only gets visible if the boolean is checked by the user.
Is it possible in NAV 2009 R2? and how?

Thanks in advance

mohana_cse06 · 2015-11-29

yes, it is possible and what did you try and what is not working?

poppins · 2015-11-29

mohana_cse06 wrote: »

yes, it is possible and what did you try and what is not working?

Thank you for your answer

First of all, I tried to set the Visible property of the text field to "Bool1" (the boolean field, "Bool1" has the property IncludeInDataset set to TRUE).It did not work

Then, I tried the following:
I created a boolean variable "Bool2" with the property IncludeInDataset set to TRUE.I set the Visible property of the text field to "Bool2" and I added the following code under the OnValidate trigger of "Bool1":
If Bool1 then Bool2 :=TRUE;
It did not work too

How shall I proceed then?

rajavenkat74@gmail.com · 2015-12-15

in NAV 2015,2016 we are not able to change the visibility of request page fields . INstead of that we can achieve this by defining them in another group and group visibity can be

Modified at Runtime/Dynamically display fields in request Page.

dynamicsuser.net/forums/t/87389.aspx

mdPartnerNL · 2015-12-15

Do you know a default report where this is done?

rajavenkat74@gmail.com · 2015-12-16

I don't know if an default report having such Option, we can easily achieve it

Dynamically hide/display fields in Report request page - NAV 2009 R2

Comments

Categories