AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Multi Select Attrib...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Multi Select Attribute selections to print with breaks

Acumatica Report Designer
Last Post by ATC 1 week ago
8 Posts
4 Users
1 Likes
60 Views
RSS
Angeles Carita
Posts: 3
 Angeles Carita
Topic starter
March 14, 2023 3:38 pm
(@acarita)
Member
Joined: 1 month ago

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?

image
image

 

Topic Tags
Attribute
7 Replies
Kurt Bauer
Posts: 43
 Kurt Bauer
March 14, 2023 4:33 pm
(@kurtybauer)
Member
Joined: 3 years ago

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

Reply
Angeles Carita
 Angeles Carita
(@acarita)
Joined: 1 month ago

Member
Posts: 3
March 15, 2023 8:20 am
Reply toKurt BauerKurt Bauer

@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.

Reply
mcraig
Posts: 52
 mcraig
March 14, 2023 5:03 pm
(@mcraig)
Member
Joined: 3 years ago

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

Reply
ATC
 ATC
(@atc)
Joined: 2 years ago

Member
Posts: 4
March 15, 2023 8:53 am
Reply tomcraigmcraig

@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.

 

image
Reply
Angeles Carita
Posts: 3
 Angeles Carita
Topic starter
March 15, 2023 8:22 am
(@acarita)
Member
Joined: 1 month ago

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.

Reply
Kurt Bauer
Posts: 43
 Kurt Bauer
March 15, 2023 9:52 am
(@kurtybauer)
Member
Joined: 3 years ago

 

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

ReportAttributes
Report
ColorsAttrib
Reply
ATC
Posts: 4
 ATC
March 15, 2023 10:48 am
(@atc)
Member
Joined: 2 years ago

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? 

image
Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Topic Tags:  Attribute (2) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,268 Topics
  • 9,982 Posts
  • 1 Online
  • 1,834 Members
Our newest member: Derek Wong
Latest Post: Change the number of rows in the check remittance field
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×