Printing Parent and child data in the detail section 2

[wgg]

Hello

I am trying to print a report with data from the parent table and data from the child table on the same detail line. As is expected, the parent table information is repeated for as many records as the corresponding child record. Is it possible in Crystal to suppress the parent table data to print once for ever set of child table data?

For Example: The following is what happens:

Customer Order number
A 001
A 002
A 003
B 004
B 005

Is it possible to get the following to happen? Where the customer name is only repeated once for every order corresponding to the customer?

Customer Order number
A 001
002
003
B 004
005

wgg

 

[mmaz]

Create a group for your parent data field, and leave the child data in the details section. You should then only see the parent data once for associated child data.

 

[wgg]

Thank you (mmaz)for your speedy help
wgg

 

[dgillz]

You do not need to create a group you can just right click on the parent data field and select "Suppress if Duplicated". Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[wgg]

Thanks.

WGG

 

[wgg]

Hello dgillz

I right click on the parent data field and select "Suppress if Duplicated" as you suggested but this suppresses all other record occurences of the parent table field suppressed. Like in the example which I listed earlier, If customer A has another order I would like customer A printed again.

For example, this is what I would like to happen:
Customer Order number
A 001
002
003

A 008
009
010

B 004
005

B 006

When I use the "Suppress if Duplicated" this is what happens:

Customer Order number
A 001
002
003

008
009
010

B 004
005

006

wgg

 

[dgillz]

Wgg-

Create a running total field and make it a count field, evaluate on every record, reset on change of group (order # I think). Then right click on the customer field and conditionally suppress if {#Count} > 1

If you are on a version earlier that V7 then let me know as running totals prior to 7 are a whole different ballgame. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[wgg]

Thank you very much. I'll give it a try.

wgg