First let me say I'm learning HTML and WebFocus self-serve application development as I go along.

What I'd like to do is emulate the Demo from the IBI website that allows a user to click on an image to select output (HTML, GRAPH, PDF, EXCEL). I'd like to allow my users to select HTML,EXCEL or PDF.

I've viewed the source and tried to set up my HTML accordingly. The following is my code and html.

I would greatly appreciate any guidance on this topic that you can offer.

Thanks
V

Focexec:
TABLE FILE BU01TB10
SUM JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER
DECEMBER
BY CD_CNTL_ENTITY
BY CD_BDGT_AREA
BY CD_PROJECT
BY CD_COST
WHERE CD_PROJECT EQ '&PROJIS'
WHERE CD_BDGT_AREA EQ '&BAIS'
WHERE CD_COST EQ '&CCIS'
ON TABLE SET STYLE *
ENDSTYLE
ON TABLE PCHOLD FORMAT '&OUTPUTIS'
END


HTML CODE FOR IMAGE SELECTION:
<td valign=middle align=center><b>HTML</b><br>
<input type="image" id=HTMLReport value="HTML"
name="OUTPUTIS"
src="http://webfocus/ibi_html/TestVBIS/gifs/HTML.bmp" valign="middle" align="center" ALT="HTML"
*****="document.RUNFORM.OUTPUT.value='HTML'" >
</td> "

***** = ONCLICK .... I couldn't get it past forum restrictions any other way....

I get the following error:
0 ERROR AT OR NEAR LINE 18 IN PROCEDURE BUD00030FOCEXEC *
(FOC295) A VALUE IS MISSING FOR: OUTPUTIS


Thanks again for any help you can offer ......

It is convenient to use JavaScript for launching WebFOCUS report from the HTML page.
I am usually using something similar to the following "skeleton" of the page:



...
<script type="text/javascript">
...
function runReport(outfmt) {
var frm = document.getElementById("runForm");
...
frm.OUTFMT.value = outfmt;
...
frm.submit();
}
...



...

action="/ibi_apps/WFServlet"
method="post">



...

..
onclick="runReport('GRAPH')"/>
onclick="runReport('HTML')"/>



There are plenty ways for running WebFOCUS reports, and mixing it with HTML,
JavaScript, ASP, PHP, Java/JSP etc., it is just a simple example.

The error message you receive is the result of mismatching names of
the parameters within the form and the report:
Report: &OUTPUTIS
Form: document.RUNFORM.OUTPUT

Hope this helps
Grzegorz

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

Thanks for the help ..... But I'm still stuck....

I changed my Focexec to match my variable names...
ON TABLE PCHOLD FORMAT '&OUTFMT'

I don't have my HTML right yet...... I've changed it to what I think it needs to be based upon GRZEGORZ reponse to my request for assistance..... But that leaves me with questions...

How does it know to submit my focexec named BUD0030 ?

AND

I get this error....
WebFOCUS was called with an invalid request.








<script type="text/javascript">

function runReport(outfmt)
{
var frm = document.getElementById("runForm");

frm.OUTFMT.value = outfmt;
frm.submit();
}

face="Arial" size=4 color="red">Budget Information System
Selection for Project Detail

Select Budget Area: !IBI.FIL.BAIS; Select Cost Code: !IBI.FIL.CCIS; Select Project: !IBI.FIL.PROJIS;

HTML ALT="HTML" onClick="runReport('HTML')"/> Excel ALT="Excel" onClick="runReport('EXCEL')"/> PDF ALT="PDF" onClick="runReport('PDF')"/> onClick="document.RUNFORM.OUTPUT.value='REPORT'" >