Go Back > Forum > Baan SIGs > Code & Utilities

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 40

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 26th March 2002, 18:57
sitarammani sitarammani is offline
Junior Member
Join Date: Jan 2002
Posts: 14
sitarammani is on a distinguished road
Using MS Word as Report Tool with Baan

Formatting Baan output to MS Word
I borrowed the idea of using [Bookmark] feature I found on the net.

Created MSWord Template (as a .doc file)

Created Book marks in the template,where data from Baan will fill in the blanks .

create the output from Baan as follows:
1*Path of output file to be created in the Win-PC-Terminal
2*Path of the template file which should be located in the pc
3*Header, Detail, Footer Indicator
4*The book Mark to be located in the template
5*The value to be placed at the bookmark

The paths[1,2] are captured in the Report Session's Form

The above 5 fields are separted by "|"

The above output file
will be sent to a batch file residing in c:\windows say Baan2Word.bat

Baan2Word.bat will invoke a VB6 program Baan2Word.exe. <>Baan2Word.exe will open the template file
<>Locate the bookmarks and fill in the blanks.
When it senses the line type is detail it will handle the table row in the template file iteratively.
it will save the output doc file as suggested in field 1.

It can handle any number of output files to be created.

Finally it will create a batch file with a Start FileName.Doc for the user to see and print the output.

If you would like to try it
open ms-word
place cursor at some point
Insert+BookMark, provide a name
close the window.
Create as may BookMarks you need.
To view the book marks
Select tools menu, options check bookmarks on ok.
The placed Book marks will be visible as 'I'

download the attachment.
the attachment contains:
The Source code for the VB6 program
Copy of the templates
Sample output into ms word
Sample output from Baan for conversion to word

all for free, no strings attached, no warranty, no liability, no damages claimable from me.

Sitaram Mani
You must ensure there is a "footer" line type
after (all of the) detail line type. The footer bookmark value may also be filled with " ".
Attached Files
File Type: zip (33.4 KB, 582 views)

Last edited by sitarammani : 4th April 2002 at 16:55.
Reply With Quote
Old 11th July 2002, 21:47
BaanTech's Avatar
BaanTech BaanTech is offline
Join Date: Mar 2002
Location: Canada
Posts: 60
BaanTech is on a distinguished road
Baan: c3 -> c4 - DB: Oracle - OS: Unix

Quick question, when you say that you then allow the user
to see the doc and print it is the printing something they
manually do, or is this automated ? eg. Using word macros ?
Reply With Quote
Old 12th July 2002, 04:56
sitarammani sitarammani is offline
Junior Member
Join Date: Jan 2002
Posts: 14
sitarammani is on a distinguished road
Printing (manual, macros)

The user prints the documents manually.
No macros defined anywhere in the document.
Reply With Quote
Sponsored Links
Old 7th December 2004, 11:28
dstuchly dstuchly is offline
Junior Member
Join Date: Apr 2002
Location: Czech Republic
Posts: 5
dstuchly is on a distinguished road
Baan: Baan IVc - DB: Informix, Bisam - OS: HP-UX 11.0
missing Baan2Word.exe

Your solution sounds interesting. To test it, the executable Baan2Word.exe ist needed. I am not able to build it from the VB source (I have only Office XP installed but no Visual Basic). Could you help, please?

Reply With Quote
Old 7th December 2004, 17:52
sitarammani sitarammani is offline
Junior Member
Join Date: Jan 2002
Posts: 14
sitarammani is on a distinguished road

I am sorry it would be very difficult for me to send you the compiled exe.
I am sure someone around should be able to help out.
Reply With Quote
Old 7th December 2004, 18:12
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
Here is a compiled file. Totally untested.
Attached Files
File Type: zip (6.5 KB, 202 views)
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote

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 Off
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post Community Bulletin 01/05/2002 patvdv About 0 1st May 2002 16:04
Baan World Users conference in Orlando chadwickh General Discussion & Chat 7 3rd November 2001 22:55
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44

All times are GMT +2. The time now is 08:51.

©2001-2018 - -