Re: report

> Can I run reports automatically in batch at night?
yes - windows AT command.

> Can I have the reports written to a file automatically at night?

yes. Destype=file desformat=[output type, ie. pdf] desname=filename

> Can I have the reports automatically emailed at night?

yes. Script it with VBScript and WSH at the command level and use something like Outlook mail automation as an example.

> Can I use SQL *Plus code?

SQL*Plus can be used to create reports too. I first write any report in SQL*Plus. If I can't get it working there, than Reportwriter isn't going to do much more for me (at least as far as getting the base data and the columns I want to order by). SQL*Plus can also spool to file and run in batch. It's great for Data Extracts too!

> Can I have the reports displayed in HTML format on an intranet?

Yes. You can have a reports server setup on your machine, and parameter forms show up as web forms through the reports CGI. Output can either be HTML, HTMLCSS, PDF or even others. It takes about 1 hour to setup under PWS (personal web server), and you can have it showing the demo reports in NO time.

> If the answer is yes to some of these could you explain how.

I'd recommend reading some manuals.

> Also how good is it compared to other reporting tools.

Never used others. The only other tool I've used for reports is SQL*Plus, PRO*C, or PRO*Cobol. The latter two on a DEC OpenVMS system. Received on Mon Oct 30 2000 - 04:11:10 CET