Style Formula
Style Formula
(OP)
Hello,
We use a system called ECI M1... I am working on a grid in M1 and trying to put in a style format.
Here is the formula:
app.iif(fields("lmlTimecardType").value="2","Style1",app.iif(fields("jmoActualProductionHours").value >= (fields("jmoEstimatedProductionHours").value),"Style2","blank" is null))
Right now I'm receiving a object error which I am sure that it's for the blank is null. How can I change this part of the formula where it will ignore the null values..
app.iif(fields("jmoActualProductionHours").value >= (fields("jmoEstimatedProductionHours").value),"Style2","blank" is null))
We use a system called ECI M1... I am working on a grid in M1 and trying to put in a style format.
Here is the formula:
app.iif(fields("lmlTimecardType").value="2","Style1",app.iif(fields("jmoActualProductionHours").value >= (fields("jmoEstimatedProductionHours").value),"Style2","blank" is null))
Right now I'm receiving a object error which I am sure that it's for the blank is null. How can I change this part of the formula where it will ignore the null values..
app.iif(fields("jmoActualProductionHours").value >= (fields("jmoEstimatedProductionHours").value),"Style2","blank" is null))
Talk To Other Members
RE: Style Formula
ECi M1 is not part of Crystal Reports.
I don’t know that Tek-Tips has a forum for ECi M1.
Each ERP system has its own properties and methods.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Style Formula
RE: Style Formula
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Style Formula
RE: Style Formula
If not isnull({table.field} or
Trim({table.field})<>“” then //replace these iPad quotes!
<your style condition>
-LB
RE: Style Formula
app.iif(fields("lmlTimecardType").value="2","Style1",app.iif(isnull(fields("jmoEstimatedProductionHours").value) ="","Style3",app.iif(isnull(fields("jmoActualProductionHours").value) ="","Style3",app.iif(fields("jmoActualProductionHours").value >= (fields("jmoEstimatedProductionHours").value),"Style2",""))))
And I'm getting a "Cannot cast DBnull. value to type"system.decimal.' Please use a nullable type. Any ideas?
RE: Style Formula
Something like a FinishDate might be NULL, but not some DURATION.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Style Formula
RE: Style Formula
HOURS, a decimal DURATION, ought not be NULL, if there are indeed no HOURS, but ought to be ZERO if there are no HOURS.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Style Formula
If not isnull({table.date}) or
{table.date}<>date(0,0,0) then...
In Crystal iif() used to throw errors when nulls were involved, if I remember correctly. This might be an outdated issue though. So you also might want to try alternative syntax.
-LB