April 05, 2007, 11:00 AM
Davidgerror message when creating pivot table
I am trying for first time to create a pivot table using developer studio and am getting an error message "invalid set command". I have not specified any set command. Any ideas?
April 05, 2007, 11:26 AM
FrankDutchDavid
show us the complete FEX and we might be able to help
put the code in between 'CODE /CODE' marks
the code marks need brackets around them
this is code
Frank
April 05, 2007, 02:18 PM
DavidgBelow is the code...
JOIN
LOCNINVP.LOCNINVP.PARTNBR IN LOCNINVP TO MULTIPLE PARTMSTP.PARTMSTP.PARTNBR
IN PARTMSTP AS J0
END
TABLE FILE LOCNINVP
PRINT
ONHAND
BY FXLOCATR
HEADING
"Locator Pivot Table"
"Sum of parts by Locator"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K PIVOT
CACHEFIELDS PARTNBR
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
April 12, 2007, 01:54 PM
KerryHi David,
Has this issue been resolved?
I am wondering, are you using Oracle table in this issue? I also ran some search on online documents and came across the following topic which may be of interest:
Receiving a Invalid control command when SETTING DEFAULTHope this helps.
Cheers,
Kerry
April 12, 2007, 02:14 PM
Tom Flynnquote:
JOIN
LOCNINVP.LOCNINVP.PARTNBR IN LOCNINVP TO MULTIPLE PARTMSTP.PARTMSTP.PARTNBR
IN PARTMSTP AS J0
END
TABLE FILE LOCNINVP
PRINT
ONHAND
BY FXLOCATR
HEADING
"Locator Pivot Table"
"Sum of parts by Locator"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K PIVOT
CACHEFIELDS PARTNBR
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
ENDSTYLE
END
-RUN
June 22, 2007, 02:36 PM
NickDavid,
This is because we have a global setting for SET EMPTYREPORT = ON. In your fex you need to add SET EMPTYREPORT = OFF and the pivot table will display.