I'm attempting what I thought would be a dead simple bursting job in ReportCaster. I have a small Excel output (code below) and I am getting the following error:

Task error: NO FIELD IS SPECIFIED ON THE LEFT HAND SIDE OF THE ASSIGNMENT: -SET &


However I do not have a -SET in my FEX anywhere.

When I ru the FEX in Dev Studio it runs as expected. I am running DEV Studio version 8007



Code:

-DEFAULTH &CustomWhereStatement = 'WHERE SCHEDGROUP EQ ''DISTRO2''';
-DEFAULTH &CustomWhereStatement2 = 'WHERE STORE_DIVISION EQ 1';
-RUN

JOIN CLEAR *
JOIN STORE IN EBRRPT_RPT_SI_DVP_SHRINK_FOCUS_CALL_STORES_TBL TO UNIQUE STORE_NUMBER IN STORE_MASTER TAG J0 AS J0

TABLE FILE EBRRPT_RPT_SI_DVP_SHRINK_FOCUS_CALL_STORES_TBL
PRINT *
BY STORE
ON TABLE HOLD AS HLD_FILE60
END


DEFINE FILE HLD_FILE60
TYRATE/D7.2%S=TYRATE*100;
PREDICTEDSHRINKRATE/D7.2%S=PREDICTEDSHRINKRATE*100;
OPTRATE/D7.2%S=OPTRATE*100;
END

TABLE FILE HLD_FILE60
PRINT
 STORE_DIVISION AS 'DIV'
 REGION AS 'REG'
 DISTRICT AS 'DIST'
 STORE_NUMBER AS 'STORE'
 T0_TY/D10CBM AS 'LY SHRINK'
 T1_TY/D10CBM AS 'LY SALES'
 TYRATE AS 'LY RATE'
 PREDICTEDSHRINK/D10CBM AS 'FCST SHRINK'
 PROJECTEDSALES/D10CBM AS 'FCST SALES'
 PREDICTEDSHRINKRATE AS 'FCST RATE'
 VARBPS/D10CB AS 'VAR BPS'
 PROJECTEDINVDATE AS 'PROJ INV DATE'
 FMONTH AS 'PERIOD'
 FYEAR AS 'YEAR'
 OPTRATE AS 'OSR'
 SCHEDGROUP NOPRINT

BY STORE_DIVISION NOPRINT
BY REGION NOPRINT
BY STORE_NUMBER NOPRINT

&CustomWhereStatement.EVAL
&CustomWhereStatement2.EVAL

-*ON TABLE SET PAGE OFF
ON TABLE SET HTMLCSS ON
-*ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT XLSX
-*ON TABLE SET UNITS INCHES
ON TABLE SET STYLE *

-*TYPE=REPORT, FONT='ARIAL', SIZE=8, JUSTIFY=CENTER, TITLETEXT='Shrink Focus Call Stores',$
TYPE=REPORT, FONT='ARIAL', SIZE=8, JUSTIFY=CENTER, $

TYPE=TITLE, STYLE=BOLD, BACKCOLOR=BLACK, COLOR=WHITE,$
ENDSTYLE
END
-RUN

  

This message has been edited. Last edited by: FP Mod Chuck,

1. Does this code run without scheduler?
2. Can you run it with -SET &ECHO=ALL and see what the substitutions look like?
3. Does it work if you don't Burst it?

quote:

Originally posted by BabakNYC:
1. Does this code run without scheduler?
2. Can you run it with -SET &ECHO=ALL and see what the substitutions look like?
3. Does it work if you don't Burst it?

Yes, it runs just fine in DEV Studio when I run it manually. Its the oddest thing.

Does it run on WebFOCUS (not Dev Studio?)
What do you see in &ECHO=ALL;
Does it work without the Burst?
Does it work if you Burst but use FORMAT HTML?
Has it worked in the past or is this a brand new report?
Does Scheduler work on a simple TABLE FILE CAR PRINT * END?

Manglum

Also check to see if there is a pre or post processing procedure that may have the bad code in it.

quote:

Originally posted by FP Mod Chuck:
Manglum

Also check to see if there is a pre or post processing procedure that may have the bad code in it.

This was it! I had a stray space!