Display text of a computed field inside a report
Hello,
I have a dropdown that reads from a report. Inside my report, one of the columns is the concatenation between 2 fields.
I want this column to be displayed inside my dropdown, it is selectable inside Property for display text of this dropdown , but, upon save, it is generating an error.
We cannot use a computed field for the display ?
Can you please help?
Thanks,
Rosy
Message was edited by: Lochan to add Category
Optus
AU
Hi Rosy,
My assumption is, you have used custom DB function to concatenate two fields in RD. If this is the case, execute the RD from designer studio and find for which value you custom function mapped to, you can verify it "pyMapping" page list under "pyReportContentPage" clipboard page.
Once you identified the mapping, the same property can be used to store in the clipboard.
Hope this helps...!!!
Process 360
IN
Hi Satish,
Suppose that we have mapped pyTextValue(1) to the drop down and later the report definition is modified and one more column is included above the current column which also makes use of some text function then the pyTextValue(1) would be pointing to this newly added column. I was wondering if there is any better approach?
Optus
AU
Hi Bhanu,
As you expected, Pega dynamically changes the mapping for the newly added columns. In that case retrofitting is required to the drop down control.
Pegasystems Inc.
US
Hi Rosy,
For your use case, I am thinking that if the property (used for the special column to be displayed inside your dropdown) can be defined to select 'Field Value' as the Table type.
In the Field value definition, you can use two concatenated property references.
https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
Thanks,
Susan