>>I'm needing to concatenate records together into a large string which I will reprint at the bottom of my report. I thought I was clever in planning to do this as a report variable, but it seems report variables can only be numbers....
>>
>
>
>Report variables can be strings too...
>
>I would initialize a report variable and then in the report, call a function from the detail band that does a
>
>vMyString = vMyString + SourceTable.Field
>
>and then place vMyString in the footer.
To add to what Eric has said, If you are setting up the variable with the report writer there is a text box that is labeled "Initial Value" place a "" in that to make it a string. By default it is a 0.
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com