Is there a way to display a report output as a bulleted list? I know we can try using DEFINE or COMPUTE to display an image, but is there any other way.
We are using WF 8105, but I am also interested in knowing if there are any new features in later versions as we are planning on upgrading.This message has been edited. Last edited by: FP Mod Chuck,
December 11, 2019, 03:38 PM
BabakNYC
I doubt it. But just to be sure you want to see a list of country with Bullets?
WebFOCUS 8206, Unix, Windows
December 11, 2019, 03:59 PM
Waz
If its HTML, then you can use CSS to do it.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
December 11, 2019, 04:11 PM
Deepti2
BabakNYC, Yes, I want to see a list of countries with bullets.
Waz, We want it either in Word or PPT, and since we didn't find much on styling Word, we are leaning towards PPT.
December 11, 2019, 06:22 PM
vaayu
Howz this for a start
TABLE FILE CAR
PRINT COUNTRY
COMPUTE UL/A100V = '<ul><li>'| COUNTRY |'</li></ul>';
END
I'm not sure if the symbol font is universally available. This would be compatible with multiple output formats.
TABLE FILE car
PRINT
COMPUTE BULLET/A1= HEXBYT(183,'A1'); AS ''
COUNTRY
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=DATA, COLOR=BLUE, COLUMN=BULLET, FONT=SYMBOL,$
ENDSTYLE
END
WebFOCUS 8.2.06
December 12, 2019, 09:17 AM
pav
Good Morning,
Like this,
TABLE FILE CAR
PRINT
CAR
COMPUTE TEST/A50=HEXBYT(127, 'A1')|COUNTRY;
ON TABLE PCHOLD FORMAT PDF
END
-RUN
December 12, 2019, 10:07 AM
Fernando
Taking what Pav sent, I found that this works in PDF, HTML and powerpoint.
TABLE FILE CAR
PRINT
CAR
COMPUTE TEST/A50 = HEXBYT(149, 'A1')|COUNTRY;
END
-RUN
Fernando
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
December 12, 2019, 10:10 AM
BabakNYC
quote:
I know we can try using DEFINE or COMPUTE to display an image, but is there any other way.
All of the above involve DEFINE or COMPUTE. I don't see how you can accomplish this without one.
WebFOCUS 8206, Unix, Windows
December 12, 2019, 10:18 AM
pav
quote:
Originally posted by pav:
quote:
Originally posted by Fernando: Taking what Pav sent, I found that this works in PDF, HTML and powerpoint.
Fernando - What's your version? Code you mentioned didn't working in 8.1.05.
December 12, 2019, 10:55 AM
Fernando
Pav, I am using: WF 8.2.03
Fernando
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
December 12, 2019, 10:57 AM
Fernando
Hi All, I admit that what Pav and I have is using a compute. However, it is not using an image.
Deepti2, is that ok?
Fernando
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
December 12, 2019, 11:03 AM
Fernando
Pav, I want to thank you for trying out my version of your solution and replying.
Your solution worked for me in pdf but not html.
If I am correct, either solutions may work for Deepti2. If they do not then I would suggest finding a character that works via HEXBYT that does work.
Fernando
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
December 12, 2019, 11:11 AM
pav
Thank you Fernando for your words.
Yes, my example works only for PDF and for HTML we need to use this '&'|'#8226;'.
My version is 8.1.05.
Hoping this would be helpful for Deepti2.
December 16, 2019, 11:15 AM
Deepti2
Fernando, I tried your version and it works in PPTX.
pav, your version works in pdf, but I don't get a proper bullet point in PPTX.
dbeagan, your version also works in PPTX.
Thank you all for your help. I am going to use COMPUTE and try to make it work.