Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Code & Utilities

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 26th March 2002, 17: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'


Interested?
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
Note:
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 baan2word.zip (33.4 KB, 580 views)

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

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
  #3  
Old 12th July 2002, 03: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
  #4  
Old 7th December 2004, 10: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?

Thanks.
Reply With Quote
Sponsored Links
  #5  
Old 7th December 2004, 16:52
sitarammani sitarammani is offline
Junior Member
 
Join Date: Jan 2002
Posts: 14
sitarammani is on a distinguished road
Baan2Word.exe

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
  #6  
Old 7th December 2004, 17:12
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
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 BaaN2Word.zip (6.5 KB, 202 views)
__________________
~Vamsi
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
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 Off
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +2. The time now is 22:44.


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