from baan to excel, word, pdf, html, xml & notepad in one click!
DESCRIPTION
From Baan to Excel, Word, PDF, HTML, XML & Notepad in one click!. Introducing B2Win The “ Configure ” Option. Our goal is to convert this report (tfacp1435m000) to Excel. This is how the output is in the Device “ D ”. Minus is on the right side of the number. Titles appears in every page. - PowerPoint PPT PresentationTRANSCRIPT
From Baan to Excel, Word, PDF, HTML, XML & Notepad in one click!
Introducing B2Win The “Configure” Option
The Alternative – Run to the B2Win device
Our goal is to convert this report (tfacp1435m000) to Excel. This is how the output is in the Device “D”
Floating header
Sub totals can be done
by Excel
A missing delimiter
Minus is on the right
side of the number
Titles appears in every page
Click on “Configure” and you will get the following screen…
The header is assigned
automatically
By using the right mouse click, you can define a floating
header. Later on you choose to pivot, keep or delete it.
Define the location of the floating header value
Choose the action to be performed on the selected
floating header
Choose the data type of the
floating header
Rename the
column
Define another floating header
Deleting the floating header
After you finished
defining all your floating
headers, click on “Next”
You can split a column into
two
By using the mouse you can
move this line and do the split
System Recognized Minus Sign on right for
number
When you click “Finish”, your settings will be saved and Excel will be launched. Next time you use B2Win 5.0 with this report, the
same settings will be used
The result is two separated columns
Choosing Data type for each column
You can also Rename every column’s title
The result in Excel
Report before Parsing
Transpose Reports
This Line-By-Line report needs to be configured as a “Transpose” report for converting it as columns.
Assign the Header-Line
Assigning a group of columns
Assigning another group of columns
After you finished
defining all your column groups, click on “Next”
Delete, rename and choose the data type of each report
When you click “Finish”, your settings will be saved and Excel will be launched. Next time you use B2Win 5.0 with this report, the
same settings will be used
The result in Excel
Report before Parsing
Contact Information
NAZDAQ - Nazareth Data Quest Ltd.Tel : +972-4-608-0023
Fax : +972-4-647-0112
Get a fully operational demo version now from www.nazdaq-it.com
NAZDAQ is a global provider of Add-ons for SSA Baan Customers. Other products from NAZDAQ are B2Email, Baan Mail-Merge, Baan Hot Link, Baan2Baan, B-Notfied, Baan Color Changer and Baan Mate.