Birt Exception

Krelek1000

Has Anyone ever encountered this error?

Data (id = 1748):
+ A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: TypeError: Cannot find default value for object.
Script source: null, line: 6, text:
<compiled script>. See next exception for more information.
Error evaluating Javascript expression. Script engine error: TypeError: Cannot find default value for object.
Script source: null, line: 6, text:
<compiled script>

What I am doing is I created a SQL Subdataset that looks at the WOSTATUS and the PERSON table. If a particular person put the status I am looking for, say INPRG, then I want to return that persons name to the field.

However if the SQL statement returns null, I get the above issue. I have built a small javascript list but it is the one returning the issue...

if (!subPlanner.fetch() == false)
{
"TEST"
}
else
{
"Electronically Signed by" + row["dname"];
}

The problem is the row["dname"] because it is undefined because the fetch is false but because I define the object here, it errors out with the exception. How can I define the object outside if the SQL fails or returns no value? Anyone have any suggests on how to fix this issue?

Thanks
Ben

SpaceMan

BIRT will fail on an error in Javascript and not process from there. From your pasted code, it looks as if you forgot a semicolon after "TEST":<br />
<br />
if (!subPlanner.fetch() == false)<br />
{<br />
"TEST"<strong class='bbc'>;</strong><

---

<br />
}<br />
else<br />
{<br />
"Electronically Signed by" + row["dname"];<br />
}<br />
<br />
If that doesn't work, use a variable and store row["dname"]. Then use a conditional:<br />
<br />
var variableName = row["dname"];<br />
<br />
if (variableName.length < 1)<br />
{<br />
"UH OH!!!!";<br />
}