Report Writer

How do I concatenate several summarized report footer fields so that there are no spaces between these fields? My fields are (Count Records) and (Total Transaction Amounts). I'm having issues with converting to a string and then in concatenate function - I get the last occurence rather than totals or I get nothing.

RE: Report Writer

Tim, thanks. I have done a rendition of this but get a double float argument so I know I'm not using the correct STR argument.. I know that you are rightL it makes sense Thanks again!

Suggested answer Tim Foster 8,515 on at RE: Report Writer

Report Writer makes this thing kind of painful. Breaking it down into steps: 1. Create numeric fields that return the right data. 2. Create string fields the return the numeric data from step 1 in string format. 3. Create a string field to concatenate all the fields from step 2. 4. Make all the fields created in steps 1 and 2 invisible. Remember that you can't nest functions in Report Writer. Or VBA modification. Tim

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…