Focal Point
[SOLVED] Multiple Queries in 1 Excel Workbook in InfoAssist

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3427012196

April 01, 2019, 12:39 PM
Doug
[SOLVED] Multiple Queries in 1 Excel Workbook in InfoAssist
Is it possible to create Multiple Queries in 1 Excel Workbook yet in InfoAssist?

I'm not, unfortunately, optimistic at this time. Please change my perspective...

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




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
April 03, 2019, 09:34 PM
StuBouyer
If you are okay with the output from each query being in separate tabs than you can do this with a Document.

I doubt they will ever give you the ability to use OPEN, NOBREAK, CLOSE


WebFOCUS 8.2.03 (8.2.06 in testing)
April 04, 2019, 12:19 PM
Doug
Thanks Stu,

Frowner I doubt they will ever give you the ability to use OPEN, NOBREAK, CLOSE

?: Will thedocument contain the actual Excel File and Tabs or a rendition thereof?
April 05, 2019, 09:18 AM
BabakNYC
I think this is what you're looking for all done in an InfoAssist Document:
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

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

SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF

COMPOUND LAYOUT PCHOLD FORMAT XLSX
SECTION=Section_1, LAYOUT=ON, PAGESIZE=LETTER, ORIENTATION=LANDSCAPE, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page 1', TEXT='Page 1', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=TableChart_1, COMPONENT-TYPE=REPORT, POSITION=(0.104166 0.104166), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, METADATA='VERSION:1.0;WIDTH:4.0;HEIGHT:3.0;LEFT:0.104166;TOP:0.104166', $
PAGELAYOUT=2, NAME='Page 2', TEXT='Page 2', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=TableChart_2, COMPONENT-TYPE=REPORT, POSITION=(0.166666 0.416666), DIMENSION=(10.22916 3.822916), ARREPORTSIZE=DIMENSION, METADATA='VERSION:1.0;LEFT:1.041666;TOP:1.041666', $
END

SET COMPONENT=TableChart_1
-*component_type report
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ibisamp/car
SUM CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR

ON TABLE RECOMPUTE 
ON TABLE SET CACHELINES 100
ON TABLE SET AUTOFIT OFF
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT='Report1', SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END

SET COMPONENT=TableChart_2
-*component_type report
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ibisamp/car
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
ACROSS CAR.BODY.BODYTYPE

ON TABLE RECOMPUTE 
ON TABLE SET CACHELINES 100
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT='Report2', SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END

COMPOUND END


  



WebFOCUS 8206, Unix, Windows
April 05, 2019, 02:45 PM
Doug
Awesome Babek... You just won another point...

That removes the "doubt they will ever give you the ability to use OPEN, NOBREAK, CLOSE thought by doing the same in a 'Document'. And one point for InfoAssist.

Living and Learning... Smiler

See you at Summit!




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206