Data in sub-report copied several times in main Report (1 Viewer)

F

fred05

Registered User.

Local time

Today, 10:05

Joined

Jul 15, 2005

Messages

10

• Jul 18, 2005

• #1

Hello,

I have one main report [ClientDetails], with one sub-report [Contacts].

Somehow (and not for all of them), the list of contacts (sub-report) is repeated 2 or 3 times in the main report...

Any idea why this might be?

tx,
fred.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 04:05

Joined

Feb 19, 2002

Messages

43,213

• Jul 19, 2005

• #2

The query for the main report sounds like it contains a join to the table for the subreport. Remove it.

 

F

fred05

Registered User.

Local time

Today, 10:05

Joined

Jul 15, 2005

Messages

10

• Jul 19, 2005

• #3

My main report is a Table and the Sub-Report is a Querry. (I don't suppose this makes a difference, but I am mentionning it, just in case!)

If I use the Report Wizard, I do not get to see the links, so I cannot remove them.. or maybe you can tell me where I should look for it?

tx!
fred.

 

F

fred05

Registered User.

Local time

Today, 10:05

Joined

Jul 15, 2005

Messages

10

• Jul 19, 2005

• #4

Just in case someone has the same problem, I believe "I" have sorted my problem:

I have done a querry with all the info I needed on the report (maybe that's what you were refering to, Pat!) instead of using the tables directly with the report wizard.

I suppose this is what you are meant to do, but as I am no expert, I just thought this could interest someone with the same problem!

fred.