Crystal Report Duplicating in details?

0
votes

so I have a template in Crystal reports using vb.net, I changed my data source location and that source still contains the needed tables for my report, the problem is this... My original template displays the exact report but when I changed its data source it duplicates the data in the details section(e.g I made a query that will show 1 item only,but instead I get 4).

Here is a screenshot of my problem: enter image description here

(original at http://tinypic.com/r/5by6ih/5)

I want to alter the template rather than to make another one

1
vb.netcrystal-reportsreportduplicates

1 Answers

0
votes

This is normally down to an issue with the underlying SQL query. If you open the the report in Crystal (or visual studio) you should be able to "Show SQL Query". Run the query in Query Analyser or SQL Server Management Studio and look at the result.

If the underlying reason isn't then immediately apparent please paste the resulting output.