Crystal Reports Show surnames beginning with A-F

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Show surnames beginning with A-F

Post Reply

Post New Topic

Author	Message
Kaiser Newbie Joined: 28 Feb 2012 Online Status: Offline Posts: 11	Topic: Show surnames beginning with A-F Posted: 11 Nov 2014 at 10:39pm
	Hi I have a report which is returning too many records so I need to split it into 3 reports. I want the new reports to show records for surnames beginning with A-F, G-M and N-Z. Can anybody advise how this can be done? Thanks in advance
	IP Logged


z9962 Senior Member Joined: 04 Jul 2012 Online Status: Offline Posts: 161	Posted: 12 Nov 2014 at 12:02am
	In selection Expert, you have an option Begins with, select the surname field begins with A, B... etc... a second option is in select expert left({surname},1) in ("A","B",...etc) you may want to test both options to see which produces the results the quickest.
	IP Logged

Kaiser Newbie Joined: 28 Feb 2012 Online Status: Offline Posts: 11	Posted: 12 Nov 2014 at 12:18am
	Great, thanks Z
	IP Logged

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