WhileReadingRecords

[ajr1705]

Hi,

I need to do the following.

current data extarcted like this...

a 1 01/01/06 no
a 2 02/01/06 yes
a 3 03/01/06 no
a 4 04/01/06 yes

I would like the data to be shown like this for 'yes' records only

a (02/01/06,04/01/06)

I think you can use the WhileReadingRecords to do this but not too sure, please help

var 8.5

 

[lbass]

Create these formulas:

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar datex;
if {table.yn} = "Yes" then
datex := datex + totext({table.date},"MM/dd/yy") + ", ";

//{@display} to be placed in the report footer:
whileprintingrecords;
stringvar datex;
{table.col1} + " ("+ left(datex,len(datex)-2) + ")"

If you are actually doing this at a group level, you would need a reset formula in the group header, and the display formula would be moved to the group footer:

//{@reset}:
whileprintingrecords;
stringvar datex;
if not inrepeatedgroupheader then
datex := "";

-LB

 

[ajr1705]

lbass,

what can i say your just a ...... genius, every time i ask a question you just seem to now what the asnwer is or what i am asking you.

thanks my man