Hey;

I tried to add an logo into my sql report that will be viewed by pdf.

What i did is:

DEFINE FILE SQLOUT
IMG1/A100 = '< !--graemlin:-->ort/approot/ibinccen/images/wflogo.gif" border="0">';
END

put into into

ON TABLE SUBHEAD
"
However i can not see it.

Thanks in advance for your help.


-Maria

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

I think you can HOLD the SQL out and do the same.

1) For PDF you have to place the image in the report using WebFOCUS Style Sheet commands
2) The image has to be located in an App folder that is in the App path, and it cannot be in a sub-folder.

I copied wf_logo.gif to App folder ibisamp (which is in my App Path):

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON TABLE HOLD AS SQLOUT
END

TABLE FILE SQLOUT
PRINT *
ON TABLE SUBHEAD
""
ON TABLE SET STYLE *
TYPE=TABHEADING, IMAGE=wflogo.gif, $
ENDSTYLE

ON TABLE PCHOLD FORMAT PDF
END

Styling generally is not possible on SQLOUT unless it is a hold file produced from another TABLE FILE (as per Francis).

T

And it is also of importance to mention that, for PDF, you'll have to use the HEADING to place the image. It is the only valid place to store your image.