Hello -

I'm having trouble saving a report output to my local computer (HOLD or SAVE - I don't care because I don't need the master file.)

The query runs fine, but I get errors writing the output file.

I'm pretty sure (but not positive) this has to do with set up, environment, permissions, etc. and not so much with issuing the FILEDEF or ALLOC command.

Thanks in advance for any suggestions.

You would need to do an ON TABLE PCHOLD or use ON TABLE SET ONLINE-FMT=output type to allow it to return to the browser and let your file assocations handle the open/save functionality.

ON TABLE HOLD, ON TABLE SAVE, FILEDEF and ALLOC only refer to locations relative to the server where WF is running. They will never return data to a local PC (unless your WF server has a mapped/shared drive to your local PC.)

Darin -

Thanks for the suggestion. ON TABLE PCHOLD AS [filename] FORMAT [fileformat] does not result in a file being saved to my local computer.

I've tried ON TABLE PCHOLD ... along with FILEDEF but still no local file.

Dan,

Please update your profile signature with your product suite, releases, and platforms so that we might better help you.

Unless you are running WebFOCUS on the PC that you work on, as Darin said, you will never get the file as it is written to a directory where the reporting servers resides. You would have to allocate it permanently with a filedef and then ftp it to your desktop.

That's really all there is to it. ON TABLE PCHOLD FORMAT PDF would open Adobe Reader (if the browser has that association) or a dialogue box to open or save if it does not have the association. Same for EXL2K, ALPHA, etc. One exception would be that you cannot PCHOLD FORMAT FOCUS. Why, I don't know, but it is documented that way.

The only other thing I can think of is that you have some browser tool or pug-in that is not allowing file transfers and such. I don't think a pop-up blocker would have any effect, but you might try turning them off and testing.

If you are wanting this as a flat file on your computer you would have to have your computer mapped as a drive on the server where it is running. Kind of an ugly solution. The FTP option is actually much better. You may be able to code the FTP instructions into your fex or through report caster.

Thanks for all the information and suggestions. I will work with the WF administrator to save the output to the reporting server.

quote:

Please update your profile signature with your product suite, releases, and platforms so that we might better help you.

Dan, don't forget to do the above.

If you want to save a data file to the reporting server, you don't necessarily need to involve the administrator. You can do it right in your focexec.

One method is to use the APP HOLD directory_name. This will save the hold file and the master in the directory you specify. If the directory is not in your ibi/apps, you can do an APP MAP first to point to it. If you only want to save the data file, you can say APP HOLDDATA. Please look up these commands in Advanced Search.

Another method is APP FI or FILEDEF which are equivalent commands, the former being the more current syntax. This allows you to specify exactly where the file is supposed to go. Please look up this command as well.

Good luck.

Try this code.
-*The user must have write permission the drive/server for this to work
-*
FILEDEF DAVE DISK \\YOURCOMPUTERNAME\C$\DAVE.XLS
-RUN
TABLE FILE CAR
PRINT
MODEL
SEATS
COMPUTE SEATSPLUS/I2 = SEATS + 1;
BY COUNTRY
BY CAR
ON TABLE SAVE AS 'DAVE' FORMAT EXL2K FORMULA
END

Hopefully this will work for you