Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 31st January 2007, 13:25
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
Report with output with more than 255 char.
Baan: Other/Unknown
C/S: None/Unknown

Hello,

I need reports with more than 255 line's columns.
How can I create this in BAAN ERP Vc

I'm not able to insert a default report size with more than 255 lines.
Is there anybody who can help me?

With Regards,
Jaap Roos
Reply With Quote
  #2  
Old 31st January 2007, 13:42
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
You can either create the report in a smaller font which fits more than 255 characters, or alternatively, and depending on the kind of data the report is printing, you can create an ascii or csv file or so in your script rather than using a report layout...
Reply With Quote
  #3  
Old 31st January 2007, 13:54
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
Font en delimited file

Hi,

Thanks for your replay:
1) Can you tell me where I can define such a font?
2) How can I create a delimited asci file withhout using a report?

Thanks
Jaap Roos
Reply With Quote
  #4  
Old 31st January 2007, 14:05
en@frrom en@frrom is offline
Guru
 
Join Date: Aug 2003
Location: Belgium
Posts: 1,219
en@frrom will become famous soon enough
Baan: B50B - DB: Oracle 8.0 - OS: Win2k AS
Jaap, if you search the board you will find plenty of topics explaining how to achieve these things...
Reply With Quote
  #5  
Old 31st January 2007, 15:00
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
use seq.*

Quote:
Originally Posted by Jaap Roos View Post
Hi,

Thanks for your replay:
1) Can you tell me where I can define such a font?
2) How can I create a delimited asci file withhout using a report?

Thanks
Jaap Roos

Hello,

you can create a delimited ascii file with seq.* statements.

Regards
__________________
//Bernd
Reply With Quote
  #6  
Old 9th February 2007, 21:37
SandraDiehl's Avatar
SandraDiehl SandraDiehl is offline
Junior Member
 
Join Date: Dec 2006
Location: Sumter, South Carolina
Posts: 28
SandraDiehl is on a distinguished road
Baan: IV C - DB: Oracle - OS: Linux
I've done this many of times

I had done this several times and this is how I have done it:

You need to define variables:

long fp
long rv
string directory(1024)
string line(2048)

Then need to open the file that you are going to write to. We had designed this one to write to a directory that the users then had the results and set up by individual company.

choice.cont.process:
on.choice:
directory = "/forecast/" & str$(get.compnr())
rv = mkdir(directory)
fp = seq.open(directory & "/" & "FORECAST.txt", "w")
if fp < 0 then
if not background then
message("File o:%s could not be open", directory&"/FORECAST.txt")
endif
else
read.main.table()
endif

Once the file is open and you are processing the records you need to format and send to the file: Also remember that you have to do headers since you don't have the layout option in BaaN...

function build.report.header.file()
{
line = ""
line = line & "Customer" & "|"
line = line & "Program" & "|"
line = line & "Ship To Location" & "|"
line = line & wk1.lbl & " Units" & "|"
line = line & wk1.lbl & " Sales" & "|"
line = line & wk2.lbl & " Units" & "|"
line = line & wk2.lbl & " Sales" & "|"
line = line & wk3.lbl & " Units" & "|"
line = line & wk3.lbl & " Sales" & "|"
line = line & wk4.lbl & " Units" & "|"
line = line & wk4.lbl & " Sales" & "|"
line = line & wk5.lbl & " Units" & "|"
line = line & wk5.lbl & " Sales" & "|"
line = line & wk6.lbl & " Units" & "|"
line = line & wk6.lbl & " Sales" & "|"
line = line & wk7.lbl & " Units" & "|"
line = line & wk7.lbl & " Sales" & "|"
line = line & wk8.lbl & " Units" & "|"
line = line & wk8.lbl & " Sales" & "|"
line = line & wk9.lbl & " Units" & "|"
line = line & wk9.lbl & " Sales" & "|"
line = line & wk10.lbl & " Units" & "|"
line = line & wk10.lbl & " Sales" & "|"
line = line & wk11.lbl & " Units" & "|"
line = line & wk11.lbl & " Sales" & "|"
line = line & wk12.lbl & " Units" & "|"
line = line & wk12.lbl & " Sales" & "|"
line = line & wk13.lbl & " Units" & "|"
line = line & wk13.lbl & " Sales" & "|"
rv = seq.puts(line, fp) | writes out line
}

NOTE: Header you only need to do once, so create and send.

Now the actual data:

function build.report.detail.file()
{
line = ""
line = line & tccom010.nama & "|"
line = line & tdssc989.plni & "|"
line = line & tccom013.namc & "|"
line = line & str$(tdssc989.qnty(1)) & "|"
line = line & str$(tdssc989.valu(1)) & "|"
line = line & str$(tdssc989.qnty(2)) & "|"
line = line & str$(tdssc989.valu(2)) & "|"
line = line & str$(tdssc989.qnty(3)) & "|"
line = line & str$(tdssc989.valu(3)) & "|"
line = line & str$(tdssc989.qnty(4)) & "|"
line = line & str$(tdssc989.valu(4)) & "|"
line = line & str$(tdssc989.qnty(5)) & "|"
line = line & str$(tdssc989.valu(5)) & "|"
line = line & str$(tdssc989.qnty(6)) & "|"
line = line & str$(tdssc989.valu(6)) & "|"
line = line & str$(tdssc989.qnty(7)) & "|"
line = line & str$(tdssc989.valu(7)) & "|"
line = line & str$(tdssc989.qnty(8)) & "|"
line = line & str$(tdssc989.valu(8)) & "|"
line = line & str$(tdssc989.qnty(9)) & "|"
line = line & str$(tdssc989.valu(9)) & "|"
line = line & str$(tdssc989.qnty(10)) & "|"
line = line & str$(tdssc989.valu(10)) & "|"
line = line & str$(tdssc989.qnty(11)) & "|"
line = line & str$(tdssc989.valu(11)) & "|"
line = line & str$(tdssc989.qnty(12)) & "|"
line = line & str$(tdssc989.valu(12)) & "|"
line = line & str$(tdssc989.qnty(13)) & "|"
line = line & str$(tdssc989.valu(13)) & "|"
rv = seq.puts(line, fp)
}


Now if you need totals and subtotals you can do that as well....

Hope this helps.
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
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
solving recursion problems rmarles Tools Development 2 25th January 2005 21:23
Can the output device be selected from a field within the report? dmcgrath Tools Development 3 5th March 2002 14:29


All times are GMT +2. The time now is 00:16.


©2001-2017 - Baanboard.com - Baanforums.com