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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
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
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies