I have document with multi-select combo attributes and i need show them in my report
How to show multi-select combo attributes in Report Designer
Best answer by Steve Milner
@bihalivan15 the thread Dipak linked fits when the codes sit in a custom field. That poster had to split the field apart and ended up having a developer add a field to hold the descriptions. With real attributes you don't need to parse anything.
Each attribute on the document comes through as its own field on the document's table, named with the attribute ID plus _Attributes. You'll find them in that table's field list in Report Designer. For an attribute with ID COLOR on a service order, the field is [FSServiceOrder.COLOR_Attributes]. Add one text box per attribute with that field as its value.
A Multi Select Combo is stored as the value IDs separated by commas (RED,BLUE). The report turns each ID into its description and prints them with a comma and a space between (Red, Blue). No formula needed.
Don't join CSAnswers for this. That's the table behind the Attributes grid, and its Value field holds only the IDs with no descriptions attached, so the report prints RED,BLUE.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.