How to parameterize the title of a field in infoassist 8002This 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