Hi there!
I hope all is well with you and thanks for looking at my problem.

I’m adding additional output formats to existing html-only reports using ‘&FMT’.
(ON TABLE PCHOLD FORMAT &FMT)

When I run the report in html – no problem, I see the report and it’s all magnificent, stunning, and wonderful. When I run it in Excel (EXL2K) I receive a FOC error.
(FOC3251) IMAGE FILE UNREADABLE OR INVALID: logo.jpg

Commenting out the image file fixes it (as in it works in html and exl2k), but we “need” to have this logo in the HTML version of the report. The foc error also confuses me.
When I initially added this in (in a DEV environment) everything worked completely fine, only once brought over to our production side has the error come up.

The fex that doesn’t work is identical to the one that does work in the other environment, except for the image path which only messes up in Excel2k.

Anyone experience an issue like this?
I checked the manual, followed the directions for adding in a new image to the letter.
I also checked these forums and saw 1 related issue, where the user resolved it by copy/pasting over their image file a fresh copy. I’ve tried that as well.
Thank you so much for your help.
Shawna

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

Hiya Shawna,

I encountered this problem once before. I'm not sure if it's the same issue.

Anyway, I used Dev Studio to do the cut-and-paste over the image and it didn't solve the problem. What worked for me at that time was to do the copy outside of Dev Studio - actually going into the server and copying the image into the app folder.

I can't tell you why it was messed up either. I basically just moved on when it started to work again...

Maybe you can try this if you haven't yet and see if it works for you.

Unfortunately this this did not work for me.

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

Woohooo Success!!
AlexU helped me out with a quick fix.

In the style section where the image comes from I had:
TYPE=REPORT,
IMAGE=app/LOGO.jpg,
$

Since the image worked fine in html but threw an error in EXL2K, one suggestion was skipping the image if the output = EXL2K. Since we don't want the image in Excel anyway (it's more of a PITA b/c you'll have to delete your image to work with the data...which is the whole point of exporting to Excel) this little addition fixed everything.

-IF &FMT EQ 'EXL2K' THEN GOTO PASSLOGO;
TYPE=REPORT,
IMAGE=app/LOGO.jpg,
$
-PASSLOGO



I feel very, very silly now.

Still don't know why it originally worked in one environment and not the other though, oh well!
Thanks so much all.
Shawna

PS:
If u had wanted to include an image in an EXCEL File.
1)put the image in a DEFINE or COMPUTE with a fully qualified path in the HEADING.
2)IMGTAG/A200 = '';
3)Enclose the image tag with some conditional styling:
HEADING
-IF &FMT EQ 'HTML' THEN GOTO PASSLOGO;
" -PASSLOGO
..
..
..
-IF &FMT EQ 'EXL2K' THEN GOTO PASSLOGO2;
TYPE=REPORT,
IMAGE=app/LOGO.ext,
$
-PASSLOGO2

WebFOCUS 7.6.7
WIN XP
Excel, PDF, HTML