Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to parameterize the title of a field
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] How to parameterize the title of a field
 Login/Join
 
Member
posted
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
 
Posts: 7 | Registered: May 26, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
-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
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 7 | Registered: May 26, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Reply With QuoteReport This Post
Member
posted Hide Post
Thanks Tamra, That was helpful


WebFOCUS 8002, Developer Studio,Excel, PDF, Active Formats and HTML5
 
Posts: 7 | Registered: May 26, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to parameterize the title of a field

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.