anybody have a clue how to 'indent' in an xml dropdown list? I've googled and gotten \u0020 ,which of course doesn't work. I'm using leading dots for the time being '. . . . qtr ending' but uuuuugly.This message has been edited. Last edited by: susannah,
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
April 13, 2016, 05:19 PM
Francis Mariani
Have you tried
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 13, 2016, 05:32 PM
CoolGuy
Add some non-breaking spaces like the following?
&|nbsp;&|nbsp;&|nbsp;&|nbsp;
Of course you may need a pipe character after the ampersand due to working with WF....
8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
April 14, 2016, 03:57 AM
Wep5622
If it's really XML, then HTML entities are invalid and you need to use   instead of .
HTML and XML collapse white-space to a single space, which includes space, tab, new-line and line-feed characters. Non-breakable spaces are exempt of that behaviour.
Another option may be to insert a <CDATA! section for the indentation. Not sure if that works though...
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
April 14, 2016, 05:03 PM
susannah
quote:
Originally posted by Francis Mariani: Have you tried
oui bien sur. ne marche pas. prints out the characters, same with & # 1 6 0 TABLE FILE CAR BY COUNTRY BY CAR ON TABLE SET HOLDLIST PRINTONLY ON TABLE PCHOLD FORMAT XML END ... now the job is to get leading spaces on CAR
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
April 15, 2016, 03:51 AM
Tony A
You could try and use JavaScript to append each option, adding the spaces that you need, but multiple spaces etc. etc. etc.
Are you trying to group the cars by country in your drop down list?
If so, are the country values required to be selected?
If they are not to be selected, then look at creating your own drop down content using <optgroup>? I do this on occasion and use JavaScript to retrieve and insert as the select control innerHTML.
SET HOLDLIST = PRINTONLY
SET ASNAMES = ON
SET NODATA = ''
TABLE FILE CAR
SUM COMPUTE CTRY_GRP/A50 MISSING ON = IF COUNTRY NE LAST COUNTRY THEN '<optgroup label="'||COUNTRY||'">' ELSE MISSING; AS ''
COMPUTE CAR_OPT/A60 = '<option value="'||CAR||'">'||CAR||'</option>'; AS ''
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON TABLE PCHOLD FORMAT ALPHA
END
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
April 15, 2016, 12:23 PM
susannah
thanks T, but that's not xml... I know I can do it in html with grouplabels and other ways (like just using a !IBI.FIL) but I gotta do it in xml.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
April 21, 2016, 11:17 AM
<Emily McAllister>
Hi Susannah,
Do you mind explaining why you need the leading blanks, and why it needs to be in XML? Knowing exactly what this is for might help in coming up with workarounds.
Thanks, Emily McAllister Focal Point Moderator
April 21, 2016, 11:31 AM
Francis Mariani
WebFOCUS HTML Composer uses XML as format when retrieving data to populate all controls.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 21, 2016, 02:23 PM
eric.woerle
I'm kind of with Emily on this... Why does it need to be XML? If its a thing of needing to populate the drop downs through native HTML Composer, you can use an ajax call to populate it. The option is available in App Studio. Although my attempts at using it have been more frustrating than anything else, Susannah's needs might be more basic and something App Studio can handle. If its going to require Pre/Post processing though.... Good luck. The actual call seems to be hidden in a comment block (The xml island minimized and shoved into a comment.... smh).
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
April 21, 2016, 02:35 PM
susannah
As Francis said, xml chains. the xml requirement is a given. the leading blanks are a customer requirement.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
April 22, 2016, 04:37 AM
Wep5622
In that case, wouldn't it help to use an "external procedure" to populate the controls so that you have control over what gets generated?
That is more difficult to use in chaining, but possible.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
April 22, 2016, 08:17 AM
Tony A
S,
Try this. I don't have 7706 available but it should be ok.
T
SET HOLDLIST = PRINTONLY
SET ASNAMES = ON
FILEDEF TEMPHLD2 DISK TEMPHLD2.FTM (APPEND
-RUN
DEFINE FILE CAR
SHFT_BLNK/A1 = HEXBYT(160,'A1');
CAR_INDENT/A60 = SHFT_BLNK|SHFT_BLNK|SHFT_BLNK|SHFT_BLNK|SHFT_BLNK|CAR;
END
TABLE FILE CAR
SUM CAR_INDENT
COMPUTE CTRY/I3 = IF COUNTRY EQ LAST COUNTRY THEN LAST CTRY ELSE LAST CTRY + 1;
BY COUNTRY/A20
BY CAR/A20
ON TABLE HOLD AS TEMPHLD1
END
-RUN
TABLE FILE TEMPHLD1
SUM COUNTRY/A60 AS OPTION_DISP
COMPUTE SORT/I2 = 1;
BY CTRY
BY COUNTRY AS OPTION_VALU
ON TABLE HOLD AS TEMPHLD2
END
-RUN
TABLE FILE TEMPHLD1
SUM CAR_INDENT AS OPTION_DISP
COMPUTE SORT/I2 = 2;
BY CTRY
BY CAR AS OPTION_VALU
ON TABLE HOLD AS TEMPHLD2
END
-RUN
TABLE FILE TEMPHLD2
SUM OPTION_DISP
BY CTRY NOPRINT
BY SORT NOPRINT
BY OPTION_VALU
ON TABLE PCHOLD FORMAT XML
END
-RUN
Results in this -
Edited to add imageThis message has been edited. Last edited by: Tony A,
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
April 29, 2016, 11:04 AM
susannah
you rock large time, T!
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
April 29, 2016, 11:30 AM
susannah
T, I get this รกรกรกรก2016 March the hexbyt xlates to those funky a letters w/ accents
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID