I need to provide the option to export the report into excel and pdf format.
Can anyone suggest for this.
Thanks, User1This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 8 Windows, All Outputs
September 16, 2015, 01:57 PM
MartinY
You need IBI courses 'cause this is basics such as any other parameters.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
September 17, 2015, 01:31 AM
User1
HI,
Sorry for this question, I am new to reporting area.
I tried with below command for export option.
-*ON TABLE PCHOLD FORMAT &WFFMT.(Inline,Excel).output.
Please suggest for this, I have started reading the docs but don't have much time.
Thanks, User1
WebFOCUS 8 Windows, All Outputs
September 17, 2015, 05:04 AM
Dave
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML>,<XLSX>).output.
if you'd selected this in the GUI you wouldn't have to guess the syntax.
_____________________ WF: 8.0.0.9 > going 8.2.0.5
September 18, 2015, 01:25 AM
User1
Hi,
Without SQL passthrogh the code is fine, but with the SQLOUT not able to display in the excel.
Below is the code,
ENGINE DB2 SET DEFAULT_CONNECTION CNAME -DEFAULT &FROM_DATE='07/21/2015'; -DEFAULT &TO_DATE='08/21/2015'; SQL DB2 EX SYSPROC.test('&FROM_DATE','&TO_DATE')@ ; TABLE FILE SQLOUT PRINT * ON TABLE PCHOLD FORMAT &WFFMT.(,).output. END
Thanks, User1This message has been edited. Last edited by: User1,
WebFOCUS 8 Windows, All Outputs
September 18, 2015, 02:50 AM
Tony A
quote:
but with the SQLOUT not able to display in the excel.
This is why training is so important - you would learn why this is not possible.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
September 18, 2015, 05:40 AM
User1
Hi,
Thanks for your suggestion, need to attend some training.
I read in one forum that first need to hold that result in one file then I can take that result in excel.