Combine multiple records into field, then group

[Drus]

I want to combine extended description fields into one field that shows at the record level. For example...

Table1:Inventory Item
Table2:Extended description on inventory items

Table1.ItemNo Table2.ExtDesc Table2.Sequence
Details >
Record #1 A100ZX Interface, tabl 001
Record #2 A100ZX e mount. 002

*****************************

I want to have the following (then group by ExtDesc)...

Table1.ItemNo Table2.ExtDesc Table2.Sequence
Details >
Record #1 A100ZX Interface, table mount. 001
Record #2 A100ZX Interface, table mount. 002


&ru

 

[crystalreporting]

Create a formula to add the two fields together, then group on the result of the formula.

Peter Shirley

http://www.linkcorp.com

 

[Drus]

You may have missed the subtlety here. Or maybe I am missing the simplicity (but I doubt it). By adding the two fields together, here is the result I get...

Table1.ItemNo Table2.ExtDesc Table2.Sequence
Details >
Record #1 A100ZX Interface, tabl 001
Record #2 A100ZX e mount. 002

*****************************

The reason for this is that Table1 to Table2 is a one-to-many relationship in a flat file database. So I don't know that it can be done unless the data were exported to Access first. Your thoughts?




&ru

 

[lbass]

Try grouping on {table1.itemno} and then create three formulas:

//{@reset} for the group header:
whileprintingrecords;
stringvar x := "";

//{@accum} for the detail section:
whileprintingrecords;
stringvar x := x + {table2.extdesc};

//{@display} for the group footer:
whileprintingrecords;
stringvar x;

Then drag the groupname into the group footer next to {@display} and suppress the details and group header sections. I'm assuming you only really want the one line.

-LB