Click to See Complete Forum and Search --> : Creating a concatenated String


zyberJock
July 14th, 2008, 12:34 AM
i have data with this display format as displayed by cr9

From TimeTo Day
8:00 10:00 M
8:00 10:00 W
9:00 11:00 F

and what would i do so that it would end up like this

From TimeTo Day
8:00 10:00 MW
9:00 11:00 F
Thanks and more power

walesytiger
July 14th, 2008, 10:10 AM
Hi

Think this is the way I'd go about it. It would be basically the same as a running total counter using Varables. ie Reset - Counter - Output



Create a group call FromTo
//Fromto grouping
{Table.From} &" "&{Table.To}

Next would be to create a variable that resets on Fromto Group

ie reset
// resetDayString
WhilePrintingRecords; StringVar DayString :=""

then to concat them together in the detail section

ie Counter
// concat Day field in detail section
WhilePrintingRecords; StringVar DayString := DayString + {Table.Day};

and outputs on Fromto Grouping

ie DayOutput
// Output in Group of FromTo

WhilePrintingRecords; StringVar Day

zyberJock
July 14th, 2008, 08:38 PM
thanks it's working fine now...