Problem with crystalreport, doubling the records

Prabhu Raja15y ago

Accepted answer

Go to Crystal Reports Menu -> Report -> Report Options -> then click Select Distinct Data for Browsing Checkbox.

Prabhu Raja15y ago

thank you

Nel15y ago

I have already solved it, but thanks.

Nel15y ago

I don't understand you. Where is that? There isn't such possibility Select Distinct Records in database menu

Prabhu Raja15y ago

Go to the database menu in Crystal and turn on "Select Distinct Records". If that doesn't work and everything is always just doubled

Nel15y ago

I do use grouping. I even tried to make a new crystalreport, but the problem persists. And when I check the data in the database, it is ok, all the records are ok, no double record. So, only in crystal report the records are doubled, even in new made reports in the same windows form.

Prabhu Raja15y ago

Hi Nel, Use Grouping in your Crystal Report to fix the problem.