Hey there,
I’m trying to add a UD field on JobHead into the job traveler form. When the report runs it displays the field name instead of the data as such:
It doesn’t seem to matter where in the report I place it.
Here are the exclusions:
The query:
The fields:
And the text box:
I’ve not run into this before. Speculate on what I missed?
Thanks,
Joe
In the expression editor for the textbox, did you select the dataset and then the field?
And shouldn’t the one in the header need a =First(...) function?
If you use the helpers in the expression editor, they’ll automatically include whatever is necessary.
Yep, I’ve tried the helpers, and pasted the value, and dragged the field from the tree, and. . .
I tried a “First” field, too, although that location is in the JobNum row group and the other fields in there seem to work okay. But I can put the field down into the detail and get the same results.
Of course, if one were to click on new Calculated Field instead of new Query Field, one might get these results. Doh.
Thanks,
Joe
Try placing it in brackets. You shouldn’t have to put worth a try.
If you exclude the label of your UD field, does it do the same? Or possibly, it throws an error.
