Is this possible? I either get too much space between the end of the asterisks and the amount or the asterisks overwrite part of the check amoun. Do I need a calculated field?
*This post is locked for comments
Thank you, MaxB! I didn't realize that option existed. I did get it to work by concatenating asterisks with the amount using the RW_Format function.
There is actually an option in Report Writer to create a new Format and fill the blank space with Asterisk. See if this works.
Deborah,
I suspect the answer is to convert the numeric value to text inside of the calculated field.
Kirk
Hi Kirk,
Yes, I did create a calculated field to concatenate the asterisks with the Check Total field (converted to a string) but the I loose the formatting of the amount - no comma (thousands separator). Do I need to include another function in there to keep the number formatting?
Thank you.
Deborah
Hi Deborah,
Have you tried making a calculated field to concatenate the leading and trailing asterisk with the check amount? This is how I make our code39 barcodes work with the SOP Number field on sales orders.
Regards,
Hi Matt,
Thanks for the post but we're trying to add leading asterisks, not trailing.
I would take a look at this blog post. It's old but should still be applicable:
dynamicsgpblogster.blogspot.com/.../how-to-add-trailing-asterisks-after.html
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
