Hi Everyone,
I am trying to develop a dashboard in FLEX (using Flex Enable). I am able to populate the data in my datagrid. I have a problem. Flex (XML file) doesn’t recognize webfocus HEADERS, SUB headings or Footings.
I want my output in a single line. Take an example for CAR file, I want my output as “Total car Sales in England is: XYZ”. I have tried few options Like the one below, but Flex gives output in a table format.

SET HOLDLIST =PRINTONLY
TABLE FILE CAR
SUM
LENGTH
WIDTH
HEIGHT
WEIGHT
ON TABLE HOLD AS SUM_HLD
END
DEFINE FILE SUM_HLD
VAL1/A30 = FTOA(LENGTH,'(D5)',VAL1);
VAL2/A30 = FTOA(WIDTH,'(D5)',VAL2);
VAL3/A30 = FTOA(HEIGHT,'(D5)',VAL3);
VAL4/A30 = FTOA(WEIGHT,'(D6)',VAL4);
END
TABLE FILE SUM_HLD
PRINT
COMPUTE C/A100 = 'Sales in region1:' || VAL1; AS ''
OVER
COMPUTE D/A200 = sales in region2:' || VAL1 | ' ' | ' sales in region3:' || VAL1 ; AS ''
OVER
COMPUTE B/A1 = '' ; AS ''
OVER
COMPUTE E/A100 = 'Grand Total:' || VAL1; AS ''
WEIGHT NOPRINT
ON TABLE PCHOLD FORMAT XML
END
-EXIT

I was told we can bind the data in the label, any ides???? How to do it ??? Appreciate any help in this regard.

This message has been edited. Last edited by: Kerry,

I'm not really clear on what you want to do, but you are correct about the Headers, Sub Headers, and Footers. That information isn't passed in an XML file. If you are just wanting a single line like 'Total Car Sales in England is : XYZ' loaded into a Flex label you could have your Focexec return that information into your Flex Datagrid and then use ActionScript to pull the information from the datagrid and set it the text of the Label.

Bob