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]IA - Parameter for SUM values
Go
New
Search
Notify
Tools
Reply
  
[solved]IA - Parameter for SUM values
 Login/Join
 
Member
posted
Using InfoAssist, is there anyway to create a &variable for the SUM field? I want to prompt a user to select the Measure they want to SUM dynamically. Can I do this in InfoAssist, and how? Like my sample below. I had to create this in InfoAssist and then manually edit the code to get a parameter for the SUM.

ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
-DEFAULT &SUMLIST = RETAIL_COST;

-SET &SUMLIST = &SUMLIST.(,).Select SUM.;

TABLE FILE ibisamp/car
SUM &SUMLIST
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
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, $
ENDSTYLE
END

-RUN

WF 8203 version. Thanks

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


AppStudio 8203
Windows
MSSQL
 
Posts: 7 | Registered: October 30, 2018Reply With QuoteReport This Post
Guru
posted Hide Post
Instructions are in the docs for IA: Adding Parameters for Data Selection at Run Time


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 263 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Parameter

The documentation worked. Thank you for showing me this. I applied the New Parameter on the Vertical Axis and the Filter came up in the Page Designer.


AppStudio 8203
Windows
MSSQL
 
Posts: 7 | Registered: October 30, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [solved]IA - Parameter for SUM values

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