report renders with multiple copies of record 1

[krysna]

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?

 

[hilfy]

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.

 

[krysna]

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.

 

[Turkbear]

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.





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

 

[krysna]

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.

 

[krysna]

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!

 

[Turkbear]

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 )





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