Subreports linking and duplicate records

[mcnallyn]

Hi there,

I’ve got a report with 3 sub reports. They need to exist independently but they do have a common field, an Incident Reference Number, and there is significant duplication between each report.

I can’t work out a way to link the reports and eliminate the duplicate records.

Can anyone help?

 

[Madawc]

Please clarify. What do the subreports show? Do you mean that if an 'Incident Reference Number' occurs on one, you don't want it on the others? Which section has the subreport? Would it be feasible to move one of them to be the main report? Which version of Crystal?

You can pass back data using Shared Variables, which can then be referenced in the next section of the main report.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mcnallyn]

Hi it's Crystal Reports v 11.

The data is from a Remedy Call Logging system, hence the Incident Reference Number, unique to each record.

The reports are independent as each requires a specific condition applied to extract accurate data. However, there will be many incidents that meet more than one condition resulting in the duplication of records.

So basically yes, if a record occurs in one report I dopn't want it showing up in another.

Each Subreport is in it's own Report Footer.

 

[synapsevampire]

If the incident is unique, then you don't have duplicate data, right?

Your descriptions are going to net questions I think, I suggest that you post more technical information:

Database/connectivity
Example data (show what's coming back to each report, at least what you consider the dupes)
Expected output (what do you want to see as output)

What you may need to do is group within the subreports on a field which is the level where you are getting the unqieness desired, and place your fields in the group header or group footer and suppress the details.

In general subreports should be avoided, not always possible of course.

We do have some Remedy experts that show up here on occasion, perhaps they can lend their insight as well.

-k