Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Would like to have a Parameter Report that shows a Fields Values (not Labels)

Avatar

Level 1

Hello,  I am trying to build a report that shows the value that we have set in a Pulldown Field.  not the Label that the user sees that is setting the field.  I see how to show that in a parameter report (using Text Mode).  However is there a way to use Text Mode to show the Custom Value we have assigned to it.  I have a few highlged in a screen shot I took of one of our Fields.  

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

This text mode will show the Option Values

displayname=Field Values
linkedname=direct
listdelimiter=<li>
listmethod=nested(parameterOptions).lists
namekey=name
textmode=true
type=iterate
valuefield=value
valueformat=HTML




View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

This text mode will show the Option Values

displayname=Field Values
linkedname=direct
listdelimiter=<li>
listmethod=nested(parameterOptions).lists
namekey=name
textmode=true
type=iterate
valuefield=value
valueformat=HTML




Avatar

Level 6

While this is a column for the Parameters... it shows the Name and the Label as well as the position the field holds on the form

 

listdelimiter=<br>
listmethod=nested(categoryParameters).lists
name=[Position] - Field Name // Label
stretch=100
textmode=true
type=iterate
usewidths=true
valueexpression=CONCAT("[",{displayOrder},"] - ",{parameter}.{name}," // ",{parameter}.{label})
valueformat=HTML
width=750