I am using the following in a procedure. The field WCCSTS is format A7. Each of these drill downs work individually but when I put them in multiselect format, I don't get the multiselect popup and the browser gives the error (Message: 'a_cont[...][...]' is null or not an object)

Below is the multiselect statement. If I comment out the lines involving WCCSTS, I get the pop up box.

TYPE=DATA,
COLUMN=N1,
TARGET='_self',
DRILLMENUITEM='Sales by Whse',
FOCEXEC=app/whse_sales_loc( \
CCDRILL=WCCSTS \
RANDOM='&RANDOM' \
),
DRILLMENUITEM='Sales by Customer',
FOCEXEC=app/costcenter_sales_loc_cust( \
CCDRILL=WCCSTS \
RANDOM='&RANDOM' \
),
$

This message has been edited. Last edited by: Kerry,

This works for me.

-SET &RANDOM = &TOD ;

DEFINE FILE CAR
 WCCSTS/A7 = EDIT(CAR,'9999999') ;
END
TABLE FILE CAR
PRINT COUNTRY
      WCCSTS
ON TABLE SET STYLE *
TYPE=DATA,
COLUMN=N1,
TARGET='_self',
DRILLMENUITEM='Sales by Whse',
FOCEXEC=app/whse_sales_loc( \
CCDRILL=WCCSTS \
RANDOM='&RANDOM' \
),
DRILLMENUITEM='Sales by Customer',
FOCEXEC=app/costcenter_sales_loc_cust( \
CCDRILL=WCCSTS \
RANDOM='&RANDOM' \
),
$
ENDSTYLE
END

Can you post the whole TABLE FILE ?

Also what does the field contain ?, could it have embedded quotes ?

It doesn't have embedded quotes. If I use only the followng, it works fine but stops working when put in multidrilldown
TYPE=DATA,
COLUMN=N1,
TARGET='_self',
FOCEXEC=app/whse_sales_loc( \
CCDRILL=WCCSTS \
RANDOM='&RANDOM' \
),
$

Here is the procedure. Thanks for your help.
-SET &ECHO=ON;
-SET &RANDOM=EDIT(&TOD,'99$99$99');

TABLE FILE EXEC_SALES_13MO
SUM
'PRIORYRMTD_SALES/D14.2!D' AS 'Sales LY MTD'
'CURRENTYRMTD_SALES/D14.2!D' AS 'Sales MTD'
'PRIORYRMTD_QTY/P14C' AS 'Qty LY MTD'
'CURRENTYRMTD_QTY/P14C' AS 'Qty MTD'
'GP_LY_MTD/D14.2!D' AS 'GP LY MTD'
'GP_MTD/D14.2!D' AS 'GP MTD'
COMPUTE GROSS_MARGIN_LYMTD%/P17.2C% = 100 * ( GP_LY_MTD / PRIORYRMTD_SALES );
AS 'GP%, LY MTD'
COMPUTE GROSS_MARGIN_MTD%/P17.2C% = 100 * (GP_MTD /CURRENTYRMTD_SALES );
AS 'GP% MTD'
'PRIORYTD_SALES/D14.2!D' AS 'Sales LYTD'
'CURRENTYTD_SALES/D14.2!D' AS 'Sales YTD'
'PRIORYTD_QTY/P14C' AS 'Qty LYTD'
'CURRENTYTD_QTY/P14C' AS 'Qty YTD'
'GP_LY_YTD/D14.2!D' AS 'GP LYTD'
'GP_YTD/D14.2!D' AS 'GP YTD'
COMPUTE GROSS_MARGIN_LYTD%/P17.2C% = 100 * ( GP_LY_YTD / PRIORYTD_SALES );
AS 'GP% LYTD'
COMPUTE GROSS_MARGIN_YTD%/P17.2C% = 100 * ( GP_YTD / CURRENTYTD_SALES );
AS 'GP% YTD'

BY KOACNA AS 'Cost Center'
BY WCCSTS NOPRINT


ON TABLE SUBHEAD
"Sales by Cost Center"

ON TABLE SET BYDISPLAY ON
ON TABLE SUMMARIZE AS 'TOTAL'
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=8,
LINES-PER-PAGE=25,
ALLOW-CHART=OFF,
ALLOW-ROLLUP=OFF,
ALLOW-PIVOT=OFF,
ALLOW-COMMENTS=OFF,
ALLOW-TOOLS=OFF,
$
TYPE=DATA,
COLUMN=N1,
TARGET='_self',
DRILLMENUITEM='Sales by Whse',
FOCEXEC=app/whse_sales_loc( \
CCDRILL=WCCSTS \
RANDOM='&RANDOM' \
),
DRILLMENUITEM='Sales by Customer',
FOCEXEC=app/costcenter_sales_loc_cust( \
CCDRILL=WCCSTS \
RANDOM='&RANDOM' \
),
$
ENDSTYLE
END
-EXIT

The message sounds like a javascript issue. I would open a case with IBI.

What browser are you using ?

Are there any messages, popups, etc.

e.g. IE 6 will have a small yellow triangle in the bottom left corner of the browser.

I am using IE version 8 and the error is the following.


Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB7.0; .NET CLR 2.0.50727)
Timestamp: Tue, 28 Jun 2011 20:17:24 UTC


Message: 'a_cont[...][...]' is null or not an object
Line: 1
Char: 1
Code: 0
URI: http://srvbitest/ibi_apps/WFServlet

Can you post the fex, I think there is something more to the report than a simple program.

Please always post code between

[CODE]

[/CODE]

tags.

quote:

BY WCCSTS NOPRINT

The above statement was the problem. I removed the 'NOPRINT' and now it works fine with just 'BY WCCSTS'. I had no idea this would cause this issue.

I would suggest putting in a case with IBI to determine what the actual issue is, and get it fixed.

Would do. Thanks.