Hello,

I'm converting to using App Studio 8104 and when trying to open up a report I'm getting this error:

Code: 1021 Type: xFDMinit
The reference to entity "groupByColumnName" must end with the ';' delimiter.

When running the report I need to pass in two parameters.


-SET &groupByColumnName= &groupByType;
-SET &groupByTimeName= UPCASE(&groupByTime.LENGTH, &groupByTime, &groupByTime.LENGTH);

thanks

This message has been edited. Last edited by: <Kathryn Henning>,

With -SET &ECHO=ALL; what do you get ? or does this error occur before running the fex ?

Hello,

When I try opening the report in App Studio Chart viewer is when I get that error. If I open the report in text view only and run from there I get a different error message.

When I leave the -SET &ECHO=AL; then I receive an error on the following:
-SET &groupByTimeName= UPCASE(&groupByTime.LENGTH, &groupByTime, &groupByTime.LENGTH);

App Studio doesn't know what to do with the UPCASE.

Here is the code for this chart.


-SET &ECHO=ALL;
-SET &groupByColumnName= &groupByType;
-SET &groupByTimeName= UPCASE(&groupByTime.LENGTH, &groupByTime, &groupByTime.LENGTH);

DEFINE FILE FUELRECHOLDTEST
DATE/MDYY=HDATE(FUELRECHOLDTEST.SEG01.date, 'MDYY');
WEEK/MDYY=HDATE(FUELRECHOLDTEST.SEG01.week, 'MDYY');
MONTH/MDYY=HDATE(FUELRECHOLDTEST.SEG01.month, 'MDYY');
YEAR/MDYY=HDATE(FUELRECHOLDTEST.SEG01.year, 'MDYY');
END

-*IA_GRAPH_BEGIN
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

GRAPH FILE FUELRECHOLDTEST
-* Created by Info Assist for Graph
SUM gallons AS 'Gallons'
BY &groupByColumnName
ACROSS &groupByTimeName
WHERE date GE DT(&beginDate);
WHERE date LE DT(&endDate);
WHERE seniorDirector EQ &seniorDirector.(OR(FIND seniorDirector IN FUELRECHOLDTEST)).seniorDirector.;
WHERE departmentDesc EQ &departmentDesc.(OR(FIND departmentDesc IN FUELRECHOLDTEST)).departmentDesc.;
WHERE teamNumber EQ &teamNumber.(OR(FIND teamNumber IN FUELRECHOLDTEST)).teamNumber.;
WHERE fleetId EQ &fleetId.(OR(FIND fleetId IN FUELRECHOLDTEST)).fleetId.;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT='WebFOCUS Report', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END
-*IA_GRAPH_FINISH

Change the format at the end of the UPCASE to 'A&groupByTime.LENGTH'


In 8.1.04 there are simplified functions.

Can you change the UPCASE to UPPER(string)

Hello,

Thank you Waz. Looks like changing to Upper(string) is going to work.

I'm going to keep this open until I get all my reports switched over.

Thanks again,
Kelly

If you want to use UPCASE in Dialog Manager, you should use EVAL when an &variable is between quotes:

  
-SET &GBTLEN=&groupByTime.LENGTH;
-SET &groupByTimeName= UPCASE(&GBTLEN, &groupByTime, '&GBTLEN.EVAL');

Hey Danny,

.LENGTH works like .EVAL, its worked within the quotes.

Hello,

This has been resolved. I replaced UPCASE with UPPER(string) and the fex file now works.

Thanks for all the help.