Possible to dynamically define DESNAME?

The subject line pretty much says it all. Is it possible to dynamically define DESNAME at runtime for an Oracle Report? The scenario is the following.... I have a number of reports that are scheduled to run regularly (every day, every week, every month, etc.) using our Oracle Reports Server. The DESTYPE is FILE, and I would like to generate the DESNAME (i.e. filename) at runtime so that I can include execution time information in the filename, thereby preventing reports from being overwritten the next time the scheduled report is run. If this is not possible, then I will have to cron a script or C program to rename the reports, which is obviously a more cumbersome solution. So far, I have tried defining DESNAME in what amounts to the command line and redefining DESNAME in my Before-Report trigger, but the command line DESNAME takes precedence. If I do not provide DESNAME when submitting the batch request, the report output defaults to the actual report module name, again overriding the DESNAME defined in my Before-Report trigger. Is there a way around this? I would truly appreciate any suggestions anyone has to offer. Thanks.

Cary

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 22 2000 - 15:43:09 CET