By using this website, you agree to our Terms of Use (click here)
I have no idea if this works, but have you tried to use a Replace() function to replace a comma with {br}.
So it would look something like Replace([TableName.Attribute], ',' , {br})
-Kurt
You may want to handle this in a sub report. You could then use a variable, to display conditionally maybe using the switch verb.
This would allow you to check the contents. Just an idea.
Matt
Thank you, Matt. It looks like we'll have to go this route and it's currently being worked on. Something so simple turns out to be a bit more complicated than expected but appreciate the direction.
I was able to use the Replace function to add the carriage return. I used a demo system to add a COLORS attribute to the stock item and then on the sales order form added a new section with the field displaying twice. Once without the formula and once with the formula.
In my report I joined InventoryItem to SOLine and thenn used this formula. =Replace([InventoryItem.COLORS_Attributes], ',', '{br}')
Hope this helps.
Kurt
Hey Kurt,
We tried to use the Replace formula on the main report (without a sub report), but when we created the Replace formula, we received back the Value ID and not the Description. Instead of showing the Description on each line, the formula field returned
1
2
4
7
Without the formula, the Attribute field showed the Descriptions in a single line, delimited by a comma.
In your example, was the Value ID and Description the same for your Attribute?