variables

[darahw]

Please help!!

I am a relatively new crystal reports user and I have been given a challenge.

I need to create a formula to combine text in detail then have it print in the group footer and reset.

Does anyone know how to do this?

Thanks VERY much!!

Dara

 

[checkai]

You will have to give more information about this task (i.e. example data)

 

[darahw]

I have a field called ProcessCode that contains values such as "VI" and "TI" and I would like in the group footer, if certain criteria are met there to be a field that contains the value of "VI, TI"

 

[chelseatech]

Formula in Group Header
WhilePrintingRecords; global stringvar ProcList:=""

Formula in Details;
WhilePrintingRecords; global stringvar ProcList;
if instr(ProcList, {table.Proc})=0 then
ProcList:=ProcList + ", " + {table.Proc};

Formula in Group Footer
WhilePrintingRecords; global stringvar ProcList;
Mid(ProcList,3) // remove leading comma and space

The first two formulas will need to be suppressed, but must be placed in those sections. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm