HI,
i have a report and its output is html. i need to add a button to this output and when the user clicks the button the same report must appear in pdf.is there a way to achieve this .
thanks

Yes,
You will need to pass a variable from the GUI.
In the following example the value of &OUTPUT will need to be HTML or PDF.

TABLE FILE CAR
SUM
     RETAIL_COST
BY
     COUNTRY
ON TABLE PCHOLD FORMAT &OUPUT
END

Also do a search there should be other example of this on here.

Hi reFocusing,
thanks for your reply but thats not the way i want.
user selects options and based on those options report is generated and the output of this report is html.now after viewing the report output to enable the user to take the print out of the output i need to create a button/link in the report which on clecking should display the same data in pdf format(printer version).
thanks

To elaborate on reFOCUSing's suggestion, I have seen HTML reports that have included buttons for EXCEL and/or PDF output formats somewhere on the report such that the report (fex) is re-executed with the chosen format.

If you're not too concerned with using button to press, I have used icons for both Excel and PDF that I add to the footing of a report. They have drilldowns associated with them in the stylesheet. When the user clicks on the icon, the report is produced in either Excel or PDF accordingly.

However, I have experiemented with buttons and there's no problem adding them. I just haven't had the opportunity to try to get them to execute a report.

Ken

Hi k.lane
can you please send me the sample code of what you have done in your report so that i can try to use it and see if it works.
Thanks
kiran

This works:

-DEFAULT &OUTPUT = 'HTML' ;

TABLE FILE CAR
SUM SALES
COMPUTE PDFIMAGE /A160 = '~img border=0 src=' || '''' ||
'http://SERVERNAME/approot/APPNAME/images/s_pdf.gif' ||
'''' || '>~/img>'; NOPRINT
BY CAR
-IF &OUTPUT EQ 'PDF' THEN GOTO NOFOOT ;
FOOTING
"-NOFOOT
ON TABLE SET STYLE *
TYPE=FOOTING, FOCEXEC=a1(OUTPUT='PDF'),$
ENDSTYLE
ON TABLE PCHOLD FORMAT &OUTPUT
END


where,

~ - The left caret.

a1 - the name of this focexec. It will drill into itself.

SERVERNAME - server
APPNAME - DS appname

Of course, it's dependent upon how things are organized in your installation.

But, this should give you the jist of what I was referring to.

I'd really be interested in the button method, but I just don't have the time to look into it.

Ken

thanks ken, i am now able to create the link and this should be enough for now and i am trying the button option and if it works i will post that too.once again thanks for your suggestion

Kiran,

The method I use involves calling JavaScript but could easily be set up to point at an HRef instead.

BUTTONS/A320 = ' || ' title="Report in Excel Format" onClick=openReport("application","report","EXL2K")>'
|| ' || ' title="Report in PDF Format" onClick=openReport("application","report","PDF")>';


The JavaScript function just creates a new window without certain toolbars etc. and would need to be included into your fex using SET JSURL. It could be extended to expect any number of parameters.

function openReport(app,fexname,format) {
URL = "/cgi-bin/ibi_cgi/ibiweb.exe?IBIAPP_app="+app+"&IBIF_ex="+fexname+"&Format="+format;
OpenWin = this.open(URL, "_blank", "toolbar=no,menubar=no,location=no,scrollbars=yes,status=no,resizable=yes");

}

T

This message has been edited. Last edited by: <Mabel>,