Need some help with data arrangement

[stormtrooper]

Hi there. I looked at one of the threads below that is similar to my problem, tried it, and to no avail.

Anyway, I have a database that looks like this:

PartNo Type Price Date Address ... etc.
1002 A 20 1/1/04 Here ...
1002 B 5 3/3/04 Here ...
.
.
.

What I want is for Crystal 9 to display this:

PartNo TypeA TypeB InitDt UpdtDt Address ... etc
1002 20 5 1/1/04 3/3/04 Here ...

Right now I'm in a middle of a mess of formulas and can only tell you that I have this grouped by PartNo.

Please advise, thanks.

 

[bdreed35]

Group by PartNo.
Place address in your group header section.
Place type field, date field in your detail section
Create a formula for counting the TypeA's

if {table.type} = "A" then
    1
else
    0

Place this in the details section.
Right click the new formula and choose Insert, Summary.
Choose sum and group 1 and click ok.
Move the field from your group footer to the group header.

Create a formula for counting the TypeB's

if {table.type} = "B" then
    1
else
    0

Place this in the details section.
Right click the new formula and choose Insert, Summary.
Choose sum and group 1 and click ok.
Move the field from your group footer to the group header.

Right click the date field in the detail section and choose INsert, Summary.
Choose min and group 1 and close.
Repeat the process for the same field, but choose max instead of min.
Move both fields to the group header.

Finally, suppress the detail section.

This should get you close except for the etc. stuff you left out.

~Brian

 

[lbass]

If you always ony have two records per part number, another approach would be to drag or copy the detail records into the group header and then create formulas using "next", as in:

next({table.date})//or

next({table.type})

Place these in the group header, and you will have the results from the first and second records displayed on one line.

-LB