Laying out data of a simple report

[rizvir]

Hello,

I am using VB6 and CR7. The question might seem very basic but I am not able to achieve the following:

The reporting of a list of coutries appears as...
Argentina
Brazil
Chile
El Salvador
....

I want it to appear as....
Argentina, Brazil, Chile, El Salvador, .....

How can that be done. Thanks in advance
Rizwan

 

[MalcolmW]

You can create a formula fwith a variable that adds the countries together. This will work for a few - a formula cannot have more than 255 characters, so that means probably 20 countries or so.
StringVar Countries ;
If Length(Countries) + Length({CountryName}) < 253 then
Countries := Countries + ', ' + {CountryName}
Else
Countries ;

Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.