×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

report renders with multiple copies of record

report renders with multiple copies of record

report renders with multiple copies of record

(OP)
We have several reports in our web application, all of which go through the same java class to render the reports as PDF's in a web browser.  One report is giving me trouble, however.  It renders fine when I render it in crystal's preview mode.  However, when I run the report in our app, I get 5 copies of each record.  I do not understand what could possibly be happening.  Can anyone shed some light?

RE: report renders with multiple copies of record

In the report definition, do you have "Select Distinct Records" turned on? (it's on the Database menu.)

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

RE: report renders with multiple copies of record

(OP)
Hi, thanks for the post!  I went and checked, and I did not.  However, I checked it and saved, and it didn't appear to make any difference.  The records still show correctly in the preview and 5 times each when running via the web application.  I have checked the db table it is reading from as well, and there are no multiple records.

RE: report renders with multiple copies of record

Hi,
Are all the fields duplicated?
Does the report have groupings? Sometimes, if the grouping is to eliminate duplicate records from one of the linked tables ( like from some one to many links ) that grouping is not correctly exported to some formats.

 

profile

To Paraphrase:"The Help you get is proportional to the Help you give.."

RE: report renders with multiple copies of record

(OP)
Yes, all the fields are duplicated.  And yes, there are 6 groups.  I will do some messing around with my tables and see if it is a one-to-many relationship problem.  Thanks for the tip!  I will update when I have more info.

RE: report renders with multiple copies of record

(OP)
I consolidated all of my data into a single table, and everything is coming up fine now.  It does look like it was a one-to-many relationship problem, as I had two tables that interacted in a somewhat non-standard way.  Once I put all the data into a single table, everything worked fine.  Thanks for the tip!  Much appreciated!

RE: report renders with multiple copies of record

Hi,
Glad to help..exports and row expansion can be very annoying and hard to deal with ( I had them a lot, so I knew where to start looking, anyway smile)

 

profile

To Paraphrase:"The Help you get is proportional to the Help you give.."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close