Report Writer

(0) Share

Report

Posted on by TinaA555

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.

*This post is locked for comments

All responses (2)

Answers (0)

TinaA555 40 on at

Like (0)

Report

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

Like (0)

Report

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