Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 19 Nov 2007 at 1:01pm
If you are familiar with SQL commands, I would a SQL statement like the following:
SELECT PrimKey, Count(*) FROM table WHERE Count(*) > 1 GROUP ON PrimKey
If you aren't familiar with SQL, then I would use a summary field and use the Group Selection formula to filter out data where the summary field =1.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 19 Nov 2007
Online Status: Offline
Posts: 4
Posted: 20 Nov 2007 at 5:13am
Thanks that worked. I used the second part using Group Selection Formulas. I was not sure where to insert the SQL code in Crystal Reports. I am trying to make the switch from Access Report to CR. I am finding CR to be very nice to work with compared to Access.
Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Posted: 20 Nov 2007 at 6:49am
Assuming you are still using Access as your data source, you would just create a query with the SQL in it. You can base your Crystal Report on the query itself, without needing to refer to the base tables themselves.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
