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     [CLOSED] Multiselect on a detailed and drilldown report
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Multiselect on a detailed and drilldown report
 Login/Join
 
Gold member
posted
Hi Everyone,

I have created a report(Report1) which will drill down to a detailed report(Report2).It works fine.Now, I am trying to include a multiselect dropdown to both the reports. My idea is to have a multiselect dropdown which can be used to filter these two reports and also the drilldown should still work. Expected flow of usage is, user will run the Report1 and when the column value like 'Computers' in PRODUCT_CATEGORY or PRODUCT_SUBCATEG is clicked it will take the user to the drilldown report(Report2). Drilldown report should obviously filter based on the value that is clicked. Drilldown report should also have an option to filter on the PRODUCT_CATEGORY, PRODUCT_SUBCATEG and Sale,Date after it is loaded. Is it possible to do it within a report(fex) itself? Please provide your inputs if it is doable.Thank you very much in advance.

Kind Regards

Report 1

  

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';
TABLE FILE wf_retail_lite
SUM WF_RETAIL_LITE.WF_RETAIL_SALES.REVENUE_US
WF_RETAIL_LITE.WF_RETAIL_SALES.GROSS_PROFIT_US
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_DATE GE '20161224';
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, ALT='Drill down report', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/metrics_sample/report2.fex(PRODUCT_CATEGORY=WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY), $
TYPE=DATA, COLUMN=N2, ALT='Drill down report', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/metrics_sample/report2.fex(PRODUCT_SUBCATEG=WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG), $
ENDSTYLE
END

-RUN


For multiselect dropdown I will use the below in where condition

WHERE PRODUCT_CATEGORY EQ '&PRODUCT_CATEGORY.(FIND WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY,WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN WF_RETAIL_LITE).Product Category.';

WHERE PRODUCT_SUBCATEG EQ '&PRODUCT_SUBCATEG.(FIND WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG,WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG IN WF_RETAIL_LITE).Product Sub Category.';

Report 2(Drilldown Report)

 
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';
TABLE FILE wf_retail_lite
SUM WF_RETAIL_LITE.WF_RETAIL_SALES.REVENUE_US
WF_RETAIL_LITE.WF_RETAIL_SALES.COGS_US
WF_RETAIL_LITE.WF_RETAIL_SALES.GROSS_PROFIT_US
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY
BY WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_DATE GE '20161224';
WHERE WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ &PRODUCT_CATEGORY.(|FORMAT=A40V).Product Category:.QUOTEDSTRING;
WHERE WF_RETAIL_LITE.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG EQ &PRODUCT_SUBCATEG.(|FORMAT=A50V).Product Subcategory:.QUOTEDSTRING;
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $
ENDSTYLE
END

-RUN
 

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 92 | Registered: June 26, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
BI Dev

Drill downs are not multi select you would have to create a html form with drop downs that allow mulit-select to run report 1 and then the drill down is what it is you click on a value and it sends that as the parameter to report 2


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2050 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi Chuck,

Thanks for your response. That is what I thought, just wanted to see if it is doable from report itself.


Webfocus 8105/8202
Windows
All Outputs
 
Posts: 92 | Registered: June 26, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multiselect on a detailed and drilldown report

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