CR group by columns

[TonyFoo]

Hi All,

I have encountered another tough task. I must create a report that has three base columns and then two columns for every contractor.

Example of what i need to do:
Contractor 1 Contractor 2
Part Spec Description Price Amount Price Amount
1 v Trench 5.00 100.00 6.00 120.00
2 f Burn 4.00 8.00 4.25 8.50
3 g Excavate 2.00 4.00 1.00 2.00

I have never done this before in Crystal Reports and am using CR11. the contractors are connected to the parts by a bid table that references the part table. Let me know if i can answer any additonal questions.

Thanks in advance,

Tony

 

[lbass]

Insert a crosstab that uses part, spec, and description as rows, contractor as the column, and price and amount as the summary fields. In the customize style tab->summarized fields->horizontal->show labels.

-LB