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,
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)
June 27, 2011, 05:52 PM
Waz
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 ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
June 27, 2011, 06:07 PM
texgator
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
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)
June 27, 2011, 07:08 PM
j.gross
The message sounds like a javascript issue. I would open a case with IBI.
June 27, 2011, 11:38 PM
Waz
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.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
June 28, 2011, 04:19 PM
texgator
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