need help using multiple detail sections

[shammont]

3 tables - employee, sickdays_used, vacationdays_used
key field is social security number.

i would like to group by ssn. in one detail section show vacation days used. in a second detail section, show sick days used. the report would look something like the following:

ssn: 222-33-4444

vac day used
9-9-2004
9-10-2004
9-11-2004

sick day used
8-8-2004

would even be better if i could show vac and sic days side by side. if you put the vac and sic day fields in the same detail, where there is 3 pieces of data in vac and 1 in sick, it will repeat. thanks

 

[synapsevampire]

Group by SSN.

You can place the Vacation and Sick days alongside each other, just right click each field and select format field->Common Tab->Suppress if duplicated.

You might find that you have row inflation though, you'll have to understand your data sources and share technical information:

Crystal version
Database/connectivity used
Example data
Expected output

If this is the case, you might consider using a View on the database to build a better data source.

-k

 

[shammont]

thanks for your help.
crystal ver is 10 standard.
using access db

master table has a social security number and info like name, address, phone, etc. key field is social sec number

linked table 1 is vacation days used. foreign key is social security field from master table. all it really has in it is vacation days used in a date format.

linked table 2 is sick days used. it is just like table one except it stores sick days as a person uses one. uses a date format.

i want the report to list in the group header all the personal info. name, address, etc. In the detail section it should list vacation days used(each on by date). the same should be done by sick days used. the following would be an example.

ssn:222-22-2541
name:john doe
address: po box 0
phone:322-555-1010

vacation day used sick day used
8-8-2004 5-8-2004
8-9-2004 6-1-2004
8-10-2004
8-11-2004

page 2 of report

ssn:333-66-5426
name:jane doether
address: po box 5955
phone:322-555-7878

vacation day used sick day used
8-8-2004 3-8-2004
7-1-2004
9-3-2004

again, thanks for your help.