Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report renders with multiple copies of record 1

Status
Not open for further replies.
krysna

krysna

Programmer
May 20, 2008
22
0
0
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?
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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.."
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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!
 
Upvote 0 Downvote
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.."
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MH6
  • Locked
  • Question
Example to Run a Crystal Report from an Oracle Stored Procedure?
Replies
3
Views
227
tomcat24
tomcat24
DSenger
  • Locked
  • Question
Developing a Crystal Report in text format
Replies
8
Views
178
kray4660
kray4660
hg05
  • Locked
  • Question
Crystal Reports Left outer join and link type
Replies
1
Views
198
PeterDimitrov
PeterDimitrov
SAINI2020
  • Locked
  • Question
Crystal Reports 2008 and SharePoint
Replies
1
Views
154
hilfy
hilfy
kad123
  • Locked
  • Question
Fixed Length txt file from Crystal Reports (11)
Replies
9
Views
254
kenhamady
kenhamady

Part and Inventory Search

Sponsor

Back
Top