Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

Retirement Notice

Baanboard is shutting down on 31-dec-2023. See: http://www.baanboard.com/baanboard/showthread.php?t=76043


User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
20%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
40%
Focus on process automation/ integrations/ Real time data/ BI analytics
13%
Stick to basics
27%
Total votes: 15

Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 29th January 2007, 21:03
baanguy2 baanguy2 is offline
Member
 
Join Date: May 2005
Posts: 66
baanguy2 is on a distinguished road
Baan: Baan IV c4 - DB: Informix - OS: AIX
Creating file name inside the report
Baan: Baan IVc4
C/S: None/Unknown

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
Reply With Quote
  #2  
Old 29th January 2007, 21:05
baanguy2 baanguy2 is offline
Member
 
Join Date: May 2005
Posts: 66
baanguy2 is on a distinguished road
Baan: Baan IV c4 - DB: Informix - OS: AIX
correction

on the third paragraph the 'login' should be read as 'logic'.

thank you
Reply With Quote
  #3  
Old 29th January 2007, 22:36
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,819
mark_h will become famous soon enoughmark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
See this thread. Other searches might turn up additional solutions.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #4  
Old 30th January 2007, 14:02
dorleta's Avatar
dorleta dorleta is offline
Senior Member
 
Join Date: Dec 2001
Location: Madrid - Spain
Posts: 139
dorleta is on a distinguished road
Baan: BaanIV - DB: All - OS: All
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
Reply With Quote
  #5  
Old 30th January 2007, 19:35
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Posts: 1,982
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7/D.3 - DB: tbase, ms-sql7, oracle10gV1, 11g, 12c, 19c - OS: HP-UX, W2K3, SLES, RHLE
Put it in before.program ?

Quote:
Originally Posted by baanguy2 View Post
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
__________________
//Bernd
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14
How can get a ascii file from Baan report tmp file jaymukh Tools Development 2 17th January 2006 22:04
Temporary device file created in BaaN report printing kaukul Tools Development 3 9th January 2006 05:03
solving recursion problems rmarles Tools Development 2 25th January 2005 22:23


All times are GMT +2. The time now is 01:18.


©2001-2023 - Baanboard.com - Baanforums.com