Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error Bursting a simple Excel Output [SOLVED]
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Error Bursting a simple Excel Output [SOLVED]
 Login/Join
 
Platinum Member
posted
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,


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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?


WebFOCUS 8206, Unix, Windows
 
Posts: 1822 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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?


WebFOCUS 8206, Unix, Windows
 
Posts: 1822 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Manglum

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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1829 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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!


WebFOCUS 8
Windows, All Outputs
 
Posts: 111 | Registered: July 23, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Error Bursting a simple Excel Output [SOLVED]

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.