option field display problem in option form of a report.

monir_asian

i have a option field itemledgerentry.entrytype in option form of a report.


i create a textbox and add it's source expr=itemledgerentry.entrytype.

but it does not show the value of list , wheni run this report.

it works when i manually enter caption and caption text= example: ,purchase,sale,positive adjustment.

but i have a question here, if database update any field, then it will not appear in report option form, because here it is manually added option field.

what is the dynamic solution of option field for display?

thegunzo

You need to copy the OptionCaptionML property from the field definition in the table Item Ledger Entry to the same property in this textbox. If this is a form, not a page you will also need to copy the OptionString property.

Chinmoy

Though not very sure whether you need to put the OptionCaptionML property, but you sure have to copy/paste the OptionCaption and OptionString properties.

Sog

I believe there is no way to show those captions in a dynamic way.

thegunzo

The OptionCaption is included within the OptionCaptionML property

mihail_kolev

Sog wrote:

I believe there is no way to show those captions in a dynamic way.

you can get it through FieldRef - OPTIONCAPTION.

Sog

mihail_kolev wrote:

Sog wrote:

I believe there is no way to show those captions in a dynamic way.

you can get it through FieldRef - OPTIONCAPTION.

Which will only show you the current optioncaption. And with some programming you can even make a string with the full optioncaption.
But the main dealbreaker is that you cannot declare a variable as optionstring in a textbox.
So I will repeat myself, I believe there is no way to show those captions in a dynamic way (in a textbox).

mihail_kolev

Sog wrote:

mihail_kolev wrote:

Sog wrote:

I believe there is no way to show those captions in a dynamic way.

you can get it through FieldRef - OPTIONCAPTION.

Which will only show you the current optioncaption. And with some programming you can even make a string with the full optioncaption.
But the main dealbreaker is that you cannot declare a variable as optionstring in a textbox.
So I will repeat myself, I believe there is no way to show those captions in a dynamic way (in a textbox).

Maybe I really can't understand what is the goal. What should be the exact workflow for this?

Sog

mihail_kolev wrote:

Maybe I really can't understand what is the goal. What should be the exact workflow for this?

The goal as described by TS

monir_asian wrote:

but i have a question here, if database update any field, then it will not appear in report option form, because here it is manually added option field.

what is the dynamic solution of option field for display?

The optionstring of the textbox on the options form/page of a report is the goal.
Unfortunatly the goal is unreachable without add-ins. (and that is only RTC).

mihail_kolev

So, the source expression is itemledgerentry.entrytype and you need to display the option string value in a report? If this is the goal, it can be done dynamically.