[SOLVED] Chained Combo displaying every other record from XML file
OK I have 2 Combo boxes chained together the first Date Period (monthly, Quarterly, Rolling 12) The second Period Ending Date. I have a fex that extracts the data from a table and saves it PCHOLD format XML. I've done the dynamic procedure and called the fex. When I execute the HTML page it loads the first box correctly. the second box it loads every other record. The XML file looks correct. I've attached the HTML below: Anyone ever seen this before. Or is it something to do with 7.6.7 which I have loaded as a localhost on my desktop for a temp project.
This message has been edited. Last edited by: Dgraff,
Duane
WebFOCUS 8.0.7 DS 8.0.7 AS 8.0.7 Windows Output: Excel, HTML, PDF, AHTML,Mobile In Focus 1982
August 18, 2009, 10:46 PM
j.gross
Please place your code contained within [ code ] ... [ /code ] tags.
August 19, 2009, 01:47 AM
Tony A
Duane,
The usual scenario for this is that you are only retrieving one field within the fex instead of two.
Use the form -
TABLE FILE filename
SUM FST.fieldname
BY fieldname
ON TABLE PCHOLD FORMAT XML
END
and you shouldn't have too many problems.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
August 19, 2009, 06:41 AM
GamP
Yes, Duane, Tony is right. When you use a fex to populate your listboxes, you have to have exactly two fields in the result set. One is for the item value, the other for the item display. That way you can have codes for the values and descriptions for the display.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
August 19, 2009, 02:29 PM
Dgraff
Thanks for the help However I needed to Display the both fields twice and the first once???
DEFINE FILE RPT_DT_DIM RPT_DATATYPE_M/A1='M'; RPT_DATATYPE_Q/A1=IF QTR_END_DT_IND EQ '1' THEN 'Q' ELSE ''; RPT_DATATYPE_P/A1=IF QTR_END_DT_IND EQ '1' THEN 'P' ELSE '';
END MATCH FILE RPT_DT_DIM PRINT RPT_PER_END_DT BY RPT_DATATYPE_M AS RPT_TYP_CD BY RPT_PER_END_DT WHERE RPT_DATATYPE_M EQ 'M'; RUN FILE RPT_DT_DIM PRINT RPT_PER_END_DT BY RPT_DATATYPE_Q AS RPT_TYP_CD BY RPT_PER_END_DT WHERE RPT_DATATYPE_Q EQ 'Q'; RUN FILE RPT_DT_DIM PRINT RPT_PER_END_DT BY RPT_DATATYPE_P AS RPT_TYP_CD BY RPT_PER_END_DT WHERE RPT_DATATYPE_P EQ 'P'; AFTER MATCH HOLD OLD-OR-NEW END
DEFINE FILE HOLD RPT_TYP/A10=DECODE RPT_TYP_CD('M','Monthly','Q','Quarterly','P','Rolling 12'); PER_END_DT/YYMD= HDATE(RPT_PER_END_DT, 'YYMD'); END TABLE FILE HOLD PRINT RPT_TYP PER_END_DT -* PER_END_DT BY RPT_TYP BY HIGHEST PER_END_DT ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $
Duane
WebFOCUS 8.0.7 DS 8.0.7 AS 8.0.7 Windows Output: Excel, HTML, PDF, AHTML,Mobile In Focus 1982