Print Page | Close Window

Last record duplicate in report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6222
Printed Date: 03 May 2024 at 7:28pm


Topic: Last record duplicate in report
Posted By: SoniTek
Subject: Last record duplicate in report
Date Posted: 30 Apr 2009 at 8:47am

I don't know why my details always duplicate the last record of my datasource. Is there away to get fix this?


Replies:
Posted By: rahulwalawalkar
Date Posted: 01 May 2009 at 2:10am
Hi
 
Open the report ,Go to  Database Menu  then check Select Distinct Records for browsing .
Can you post some sample records and let us know which record is repeated,also are you retrieving records from single table or multiple tables ....
 
cheers
Rahul

Posted By: SoniTek
Date Posted: 11 May 2009 at 8:49am

Hi Rahul,

Sorry for not answering you sooner. I've not checked on this post for awhile.
 
The crystal report that was created was using an object view from a program. There must be something extra in that object view. What I ended up doing is change the whole crystal report to use tables and that solved my problem.
 
Thanks.
 
Do you or anyone know how to group on multiple fields? I need to group my detail lines on 2 fields. I have read that you could do something with formula to group 2 fields but I don't know how.


Print Page | Close Window