If I have an EnumList Ref column and I call out the Ref column in a report using the format of <<[RefColumn]>>, it will print the list of the appropriate values from the key column of the referenced table. I understand that part. But what if I instead want to print the values of the label column of the referenced table? If I use a list deference such as [RefColumn][OtherTableLabelColumn], that field in my report just shows up blank. Why is that?
Try with dotโฆ [RefColumn].[OtherTableLabelColumn]
HI @Aleksi, that works fine for me if I make the column a Ref but as soon as I change to an EnumList Ref, I get this message:
Attachment template. Expression โ[Assigned to].[_ComputedName]โ is invalid due to: Column Assigned to in expression โ[Assigned to].[_ComputedName]โ does not contain a reference."
Thanks!
Sorryโฆ didnโt realize you were using Enumlist. As Steve said, it should create a list of values if you have values in that column.
Having the same problem
This is the error from the monitor
this is the list of values from the column **[caso_atenciones]**
on the monitor result, if I leave it like this: <<[caso_atenciones]>>
in the report will appear just the key values PAP, ASL. but I want the result to be the labels of that enum list concatenated, like this: Primeros Auxilios Psicolรณgicos, Atenciรณn en Salud
I tried <<CONCATENATE(LIST([caso_atenciones]).[attention])>>
but it gave me the same result as <<[caso_atenciones]>>
And I also tried:
[caso_atenciones]
is EnumList type Ref to another table
As mentioned above, you should be using a โlist dereferenceโ.
<<[caso_atenciones][attention]>>
Without the dot in the middle.
Now I get it, thank you very much.
It worked as intended.
This should work, assuming that dereference is wrapped in <<
, >>
. Was it? Perhaps post a screenshot of the template?
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |