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,

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

Hi Chuck,

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