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
-DEFAULTH &WF_TITLE='WebFOCUS Report';
-DEFAULT &SUMLIST = RETAIL_COST;
-SET &SUMLIST = &SUMLIST.(
TABLE FILE ibisamp/car
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $
WF 8203 version. ThanksThis message has been edited. Last edited by: cbrsm18,
Instructions are in the docs for IA: Adding Parameters for Data Selection at Run Time
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.
|Powered by Social Strata|