Different selection criteria but one report (extracting data)

[tuigvlieg]

Hi,

We are using Crystal version 8.5.3.936.

Situation I have is one table:

DOSIER Part Supplier TYPE trip
X A HENK C 2
Y B PIET C 5
2 R
5 R

I want a report that reports all type C per period. For every recort type C I want to count how many records are available with type R and I want to show details for type R also.

I don't know how to do this as all data is in the same table.

Please help

 

[dgillz]

Link the table to itself as an alias, link on Dossier=Trip.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Madawc]

Is there an inherent connection between individual type C and type R records? Your data suggests not.

If they are for particular suppliers, I would group by suppliers, maybe using Group Selection to suppress groups with no type Cs.

If they are two distinct things, then select both in a single table using Record Selection. Do a formula that defines suitable groups, something like

if {type} = "R" then "Type R"
else "Type C, supplier " & {supplier}

Madawc Williams (East Anglia, UK)