Print Page | Close Window

Distinct Count vs Count Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22856 Printed Date: 03 May 2024 at 12:15am Topic: Distinct Count vs Count Posted By: jsh8286 Subject: Distinct Count vs Count Date Posted: 16 Jan 2020 at 1:57pm Have a detail field that is "supposed" to increment by '1' for each record. So the last record (which starts at 1, 2, 3 etc...)ends at 9204 BUT the distinct count for this field is only 9192. So there are 12 records missing. Instead of sifting through nine thousand entries looking at this field to see when it skips is there a way to flag the next detail record to say it skipped? Eg. Field = 14 at record 14     Field = 16 at record 15 Can Record 15 be flagged somehow as a tip off? Thanks in advance for postings. Replies: Posted By: DBlank Date Posted: 17 Jan 2020 at 2:18am sort by that field and add either select or suppress using the next() or previous() functions e.g. field+1<>next(field)

Print Page | Close Window