baanguy2
29th January 2007, 21:03
Hi,

I have a problem in a Baan report:

I have created a report and added it to a standard Baan session, as I can not modify the standard Baan session. This report is written to create a ASCII file, which is supposed to have a different file name (depending on the date it is run on) and it will be run in a job.

The first thing i tried was to have the file name generated inside the report script and the predefined report variable spool.fileout will be replaced with the file name, this did not work.(this was in the before.report section)

then the next one i tried was to have the same login to generate the file name in the report (in after.report section) and call a shell program inside the report to rename the file but it did not work (as the file was not there in the directory when the after.report section was executed.

Please suggest if you know of any solutions.

Thank you
baanguy2
29th January 2007, 21:05
on the third paragraph the 'login' should be read as 'logic'.

thank you
mark_h
29th January 2007, 22:36
See this thread (http://www.baanboard.com/baanboard/showthread.php?t=13170&highlight=batch+date+file). Other searches might turn up additional solutions.
dorleta
30th January 2007, 14:02
perhaps you can update the ttaad300.path in the before.program section of your report, but is not a smart solution.

It vould be better a new device with a command asocciated for changing the file name.

good luck
bdittmar
30th January 2007, 19:35
Hi,

I have a problem in a Baan report:

I have created a report and added it to a standard Baan session, as I can not modify the standard Baan session. This report is written to create a ASCII file, which is supposed to have a different file name (depending on the date it is run on) and it will be run in a job.

The first thing i tried was to have the file name generated inside the report script and the predefined report variable spool.fileout will be replaced with the file name, this did not work.(this was in the before.report section)

then the next one i tried was to have the same login to generate the file name in the report (in after.report section) and call a shell program inside the report to rename the file but it did not work (as the file was not there in the directory when the after.report section was executed.

Please suggest if you know of any solutions.

Thank you

Hello,
put the changing of spool.fileout in the "before.program" section of the reportscript, this maybe work.
But you're able to write an ascii-file with seq.* also in reportscript.

Regards