Crystal Reports Select Statement - Formula

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Select Statement - Formula

Author	Message
Krazy Kasper Newbie Joined: 11 Jul 2007 Location: United States Online Status: Offline Posts: 23	Topic: Select Statement - Formula Posted: 11 Jul 2007 at 11:50am
	My Crystal Report (CR X) pulls about 25,000 records. When I run across any two transactions where every field is the same except STATUS, I want to select only that record where STATUS = I. I need help on how to structure the formula/select statement. Thanks,
	Krazy Kasper
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 11 Jul 2007 at 12:35pm
	How is your data ordered and grouped? If there are multiple statuses, is I always first, last, or somewhere in the middle? -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Krazy Kasper Newbie Joined: 11 Jul 2007 Location: United States Online Status: Offline Posts: 23	Posted: 11 Jul 2007 at 1:39pm
	Data is grouped and ordered by 2 totally different fields (ContractNumber then InvoiceNumber). There are multiple statuses; not sure if they are in any particular order. Edited by Krazy Kasper - 11 Jul 2007 at 1:40pm
	Krazy Kasper
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

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

This page was generated in 0.016 seconds.