Crystal Reports odd IN function

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

Topic: odd IN function
	<< Prev Page of 2

Author	Message
bwsanders Senior Member Joined: 05 Sep 2012 Location: United States Online Status: Offline Posts: 177	Posted: 01 Oct 2013 at 7:50am
	it's my record select so in the formula there is {co.co} = "company name" and {checkdate.startdate} = "01/01/2013" and {checkdate.enddate} = "09/26/2013" and {labor.detcode} IN ["401k", "403M", "403B", "403S", "L403B"]
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 01 Oct 2013 at 8:02am
	and you have tested each of the values seperately to make sure that each one (not just one or two) gets the expected results? I suspect that the either their is a join issue. if you can run it per value and get each to run correctly you (in theory) can use a parenthed OR statement, but there is no reason that should work over the IN statement.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 03 Oct 2013 at 4:59am
	again my 2 cents... have you tried breaking up the formula into smaller bits to 'debug' it...just to make sure that what you think is occurring, really is... In it's own way, that is the most difficult part of report writing...since there is no stepping through the code, it's a black box and it either works or it doesn't...and when it doesn't it can be difficult to figure out why. HTH
	IP Logged

<< Prev Page of 2

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.