Birt OnFetch for jdbc dataset missing ; before statement error

navydawn

I am using BIRT with Eclipse Indigo.
I am building a report using the Grouped Listing Template.
I have created an Oracle JDBC Data Source and a dataset.

When I try to create an OnFetch script for the dataset my first line is:
mxDatasetContext = MXDatasetContext.onFetch(DatasetContext);
When I start typeing my 2nd line a case statement, I enter CASE row and by the
time I'm done typing the word row I see the missing ; before statement error.

The entire OnFetch script is:
mxDatasetContext = MXDatasetContext.onFetch(DatasetContext);
CASE row(SITEID)
when "PTLOMA" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER SAN DIEGO"
var l_address1 = "Petroleum Laboratory B-70A"
var l_address2 = "199 Rosecrans Street"
var l_address3 = "San Diego, CA 92106"
when "ROTA" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER ROTA, SPAIN"
var l_address1 = "Fuels Laboratory"
var l_address2 = "PSC 819 BOX 21"
var l_address3 = "FPO AE 09645"
when "DFSP-PH" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER PEARL HARBOR"
var l_address1 = "FUEL LABORATORY (CODE 704)"
var l_address2 = "1942 GAFFNEY STREET STE 100"
var l_address3 = "PEARL HARBOR, HI 96860-4549"
when "HK" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER YOKOSUKA"
var l_address1 = "Hakozaki Fuel Laboratory"
var l_address2 = "PSC 473 Box 11"
var l_address3 = "FPO AP 96349-0011"
when "HC" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER YOKOSUKA"
var l_address1 = "Hachinoe Fuel Laboratory"
var l_address2 = "UNIT 5260"
var l_address3 = "APO AP 96319-5000"
when "TS" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER YOKOSUKA"
var l_address1 = "Tsurumi Fuel Laboratory"
var l_address2 = "PSC 473 Box 11"
var l_address3 = "FPO AP 96349"
when "SA" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER YOKOSUKA"
var l_address1 = "Sasebo Fuel Laboratory"
var l_address2 = "PSC 476 Box 7"
var l_address3 = "FPO AP 96322-0001"
when "MFD" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER PUGET SOUND"
var l_address1 = "Manchester Fuel Laboratory"
var l_address2 = "PO BOX 8"
var l_address3 = "Manchester, WA 98353-0008"
when "NFD" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER JACKSONVILLE"
var l_address1 = "Jacksonville Fuel Laboratory"
var l_address2 = "8808 Somers Road"
var l_address3 = "Jacksonville, FL 32226"
when "DFSP-GU" then
var l_lab = "NAVSUP FLEET LOGISTICS CENTER YOKOSUKA"
var l_address1 = "Guam Area Fuel Division (Code 740)"
var l_address2 = "PSC 455, Box 190"
var l_address3 = "FPO AP 96540-1082"
end;

Does anyone have any ideas what is causing this error?
Thanks,
Dawn

kclark

Here's a small example of the code that works for me with case statements<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
var grade = 'A';

switch (grade)
{
case 'A': reportContext.getDesignHandle().getElementByID(200).text = "You got an A!"
break;
case 'B': reportContext.getDesignHandle().getElementByID(200).text = "You got a B!"
break;
case 'C': reportContext.getDesignHandle().getElementByID(200).text = "You got a C!"
break;
default: reportContext.getDesignHandle().getElementByID(200).text = "You get to try again!"
}
</pre>
<br />
So it looks like it's expecting it to be inside of switch()