Crystal Reports the string is non-numeric

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

Topic: the string is non-numeric
	<< Prev Page of 2

Author	Message
chudok Groupie Joined: 18 May 2010 Online Status: Offline Posts: 70	Posted: 27 Jun 2011 at 10:21am
	NOT(isnumeric({SY0_CompanyParameters.ARAgingCategory4})) - I get 1668 records back isnull({SY0_CompanyParameters.ARAgingCategory4}) I get 0 records back so that is telling me that they are not null then. So would the best thing be to clear out the spaces on the db?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 27 Jun 2011 at 10:29am
	just add in the condition to look for an empty string and make it 0 (which will not convert to a 0 like a NULL does). IF {SY0_CompanyParameters.ARAgeByDayOrMonth} <> "D" Then 120 else if trim({SY0_CompanyParameters.ARAgingCategory4}))="" then 0 else tonumber({SY0_CompanyParameters.ARAgingCategory4})
	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.031 seconds.