Crystal Reports Show only records containing letters

Report Design

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

Topic: Show only records containing letters

Author	Message
Kaiser Newbie Joined: 28 Feb 2012 Online Status: Offline Posts: 11	Topic: Show only records containing letters Posted: 13 May 2013 at 12:27am
	Hi I am looking to return records from a field where the records are made up of letters and numbers. Some records are numeric e.g 1234, others are alphanumeric e.g. 1234A or TEMP123. How can I return only the ones that are alphnumeric and exclude the ones that are numeric? Thanks
	IP Logged


bwsanders Senior Member Joined: 05 Sep 2012 Location: United States Online Status: Offline Posts: 177	Posted: 13 May 2013 at 2:54am
	maybe you could do some thing like this if IsNumeric({field}) then "" else {field}
	IP Logged

Kaiser Newbie Joined: 28 Feb 2012 Online Status: Offline Posts: 11	Posted: 13 May 2013 at 3:03am
	Thanks bw, I tried this: if IsNumeric({PROF_CARERS.MAIN_IDENT}) then "" else {PROF_CARERS.MAIN_IDENT} but am getting 'A boolean is required'
	IP Logged

Kaiser Newbie Joined: 28 Feb 2012 Online Status: Offline Posts: 11	Posted: 13 May 2013 at 3:31am
	Actually this is working for when I create a formula field, making progress now!
	IP Logged

joeg1962 Newbie Joined: 01 Mar 2013 Location: United States Online Status: Offline Posts: 35	Posted: 13 May 2013 at 3:44am
	I just did the following for one of my fields if isnumeric({PERSON.MEDRECNO}) then "" else {PERSON.MEDRECNO} and it was fine.
	IP Logged

Kaiser Newbie Joined: 28 Feb 2012 Online Status: Offline Posts: 11	Posted: 13 May 2013 at 4:00am
	Thanks Joeg. This works fine as a formula field but is there any way of including it in the Record Selection instead? When I use it as a formula field all the other details appear apart from the ID (name, address, etc.) but I want to only display these details for those individuals with alphanumeric ids.
	IP Logged

Gurbs Senior Member Joined: 16 Feb 2012 Location: Ireland Online Status: Offline Posts: 216	Posted: 13 May 2013 at 4:44am
	if you only want to run it for cases where the medrecno is numeric, put it like this in your select record statement: not isnumeric({PERSON.MEDRECNO}) Edited by Gurbs - 13 May 2013 at 4:44am
	IP Logged

Kaiser Newbie Joined: 28 Feb 2012 Online Status: Offline Posts: 11	Posted: 13 May 2013 at 4:50am
	Thanks Gurbs, that appears to have done the trick.
	IP Logged

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