Putting duplicate entries on separate reports.

[Imbriani]

Hi,

I'm using Crystal Reports XI with an Access DB on a local machine.

I have a report in which for each lab sample there are two company names in the database. I want to be able to print one company name on the left side of the form with the address, etc. and if there is a second company name, have it print on the other side of the report under the heading "Copies to:"

Otherwise, if this is impossible, I would like to have the second company name print out on a DIFFERNT report, complete with headers and footers.

Clear?

Kathy

 

[lbass]

It depends upon your report structure. I'm assuming that the company names are two instances of the same field. One way would be to insert a group on lab sample ID. Then place the detail fields for first company name and address in the group header, and then create a formula for the second company name and address:

if next({table.labsampleID}) = {table.labsampleID}) then
next({table.company})+chr(13)+next({table.address})+chr(13)+next({table.city})+", "+next({table.state}) + " "+next({table.zip})

Format this formula with "can grow" and place it also in the group header.

-LB