Focal Point
[SOLVED] How to parameterize the title of a field

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6787093176

June 26, 2014, 12:11 AM
Prathiba
[SOLVED] How to parameterize the title of a field
How to parameterize the title of a field in infoassist 8002

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


WebFOCUS 8002, Developer Studio,Excel, PDF, Active Formats and HTML5
June 27, 2014, 01:08 AM
Ramkumar - Webfous
-DEFAULT &CAR_TITLE = 'Car Name';


After giving this, I created a chart using InfoAssist and Changed Column title of the CAR field with &CAR_TITLE, and it worked.

Is this something you are looking for? or something else?

Thanks, Ram...


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
June 27, 2014, 02:59 AM
Prathiba
quote:
&CAR_TITLE


Not exactly...
below is my fex. When i run it i get what i am expecting... parameter prompts up and i can pass the value and my column title gets the parameter which i passed.

But in Infoassist Live preview pane, once i change the title as &COUNTRY, it gets displayed as _FOC_NULL.

Is there any way to eliminate it?

ENGINE INT CACHE SET ON


-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE CAR
PRINT CAR.COMP.CAR
BY CAR.ORIGIN.COUNTRY AS '&COUNTRY'
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, HFREEZE=OFF, $
ENDSTYLE
END

-RUN

{status:'SUCCESS',hasstatus:true,exception:[]}


WebFOCUS 8002, Developer Studio,Excel, PDF, Active Formats and HTML5
July 04, 2014, 09:13 AM
Tamra
Prathiba,

In the InfoAssist preview window the &COUNTRY is being parsed as the default value and therefore is being displayed as _FOC_NULL. Even if -DEFAULT is added to the code the _FOC_NULL still appears as the default value for the title of the column.

I hope that helps.

Tamra Colangelo
Information Builders Customer Support


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
July 07, 2014, 08:15 AM
Prathiba
Thanks Tamra, That was helpful


WebFOCUS 8002, Developer Studio,Excel, PDF, Active Formats and HTML5