Extra Spacing in Report Name Merge Fields

How to remove extra spacing in a report name's merge fields

If using merge fields for a report name and you have extra spacing between the merge fields, you may need to add the LTRIM/RTRIM function in your query to remove spaces from a string. For example, if integrating with Signature, and a field is 32 characters long, but you enter 8 characters, 24 spaces will be added at the end of what you entered when you query it. Adding the LTRIM/RTRIM function resolves this.