Report producing multiple copies

[ribbons]

I just know this is a stupid mistake, some oversight on my part, but I am now officially stumped.

I am using Crystal Reports XI pulling from an Access DB and running on Windows XP. I'm relatively new to using the stand alone version of CR, but used the MS Access build in for years.

I have a form that reports laboratory results from seed viability tests. It pulls the report based on the laboratory number and the various assessments of the sample are displayed as subreports, mostly. Here's the dilemma . . . some samples produce just one page, some produce two or more pages with a small change in data (such as multiple submitters) and others produce several, IDENTICAL pages. It's the identical page result that now has me stumped.

This database has several linked tables.

The form is made up of a page header, several detail sections containing the subreports (so they will build down based on the amount of data to report) and a page footer with some standard text in it.

If anyone has had a simliar experience of could point me in the direction of a resolution, I would appreciate it much.

Ribbons

 

[synapsevampire]

Identical including page numers, or simply repeated data?

I would first off suspect any conditionally suppressed sections.

You need to isolate which section is producing the dupes, which should be simple, just place some text in the beginning of each section.

-k

 

[IdoMillet]

Check the joins in Crystal. Sounds like you either have record inflation due to a many-to-many join or due to having tables without any joins.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Ido makes a good point, however I thought that you would NOT get repeated pages, rather repeated rows in that instance, hence I guessed otherwise.

Now thta I consider it, if it'sgrouped by an entitywhich is being duped by row inflation (the query), that very well could be it.

Also Try database->Select Unique Records, however that doesn't resolve row inflation, just true dupes.

-k

 

[ribbons]

Hi all and thanks for your responses.

I am getting repeated data, exactly repeated. I don't think it is the joins, because I already worked all that out earlier with this form.

I have done some work with the suppressed sections, but I will look into that more fully as you suggested.

The database -> Select Unique Records didn't help.

This report is in the developmental stage and we are working with a new database, so I am pulling reports randomly to test the performance of the report. Odd thing about this is this is occuring on one lab number in particular in which the only element of the data pull that has four (4) entries (which is the number of reports that are being produced) is a subreport entitled "Germination". I have compared this subreport to other subreports and they are all formatted the same, as far as I can tell. It is in a details section that I have also compared to its neighbors and they are identical (again, as far as I can tell). So, I am perplexed as to what is different about this. In this same report, I have information displaying in a subreport in a details section in which there are two instances of data and it displays just fine with no duplication. So, as before, I am stumped. Is there something maybe about the subreports I have overlooked?

Ribbons

 

[ribbons]

I figured this out and thought I'd let all know in case someone is looking for this solution.

I had to put all the elements of this report, (subreports, etc.) into report headers instead of detail sections so that the data in the sub tables would not replicate on multiple reports.

Hope this helps someone.

Ribbons