Asked by:

Duplicate records in detail section of crystal report

Question

I am having some trouble with crystal reports. I have information in the details section of my reports which gets duplicated and is not suppose to. For example I have a field with numbers and I want those numbers to be listed in my report. It shows each number more than once. I am getting these records through a stored procedure and I noticed that when I excute the stored procedure in VB I only get each record once so I figured it must be a problem with Crystal Report. I hope my post is clear. Any help would be appreciated. Thanks..

The display in VB works just fine. If i right click on the stored procedure and click execute it shows the correct values once in the correct order for ex.150151152153In my crystal it shows the correct values in the correct order but it shows it a few times, for ex.150151152153150151152153150151152153150151152153I am getting these numbers based on a number in another column. For example employee ID. So i am getting each transcation number based on the employee ID. I realized that if that employee ID is in the table for example 5 times the results are duplicated 5 times. etc.

I experience the same problem. I have two tables which are being generated by two stored procedures from sql server. The two tables have one field that is the same but when i try to link the tables the report is blank (no data present in report).
Flex Developer

Tuesday, June 08, 2010 10:17 AM

Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.