By using this website, you agree to our Terms of Use (click here)
Hoping for suggestions:
We have a multi select attribute with 10 or so options that house extra default notes to print at the bottom of our report.
Trying to figure out how to add a Break in between so they print one on top of another and not in the same line separated by a ,.
Any suggestions?
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
@kurtybauer Thank you Kurt, we did try that method but seems the {br} wasn't even recognized. Maybe the way the attribute data is stored in the DB? Anyways thank you again.
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
@mcraig Thanks Matt!! That did the trick. Acumatica stores the attributes in SQL in XML: <v type="AttributeCKNOTES">1,4,5,7</v>.
When I created the sub report, the value was converted to a delimited list (seperated by a comma). I was able to pass that as a variable back to the main report. From there, I used a Replace function to replace the commas with line breaks. Thanks for pointing us in the right direction with this one.
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?
