Transcript Use Baan Data Dictionary

Baan Query Tool
Version 2.6
Easily retrieve data from the Baan database
Current Query Tools Status





Difficult to configure and install
Difficult to use
Time consuming
Expensive to configure
Expensive to run
Baan Query Tool

Quick Installation: Load few sessions and all Baan and
ERP Ln users will have access to Baan Query Tool

Easy to Configure: No ODBC or database drivers need to
be configured

Use Baan Data Dictionary: Browse tables and fields and
create a query - using the Baan data dictionary
Baan Query Tool

Baan Query Tool is fully integrated in Baan. Reports run
as native Baan reports

Can work with Baan special fields like enumerated fields,
arrays and text fields

Does not have the limitation of 255 characters, like
standard Baan reports
Easy to Find a Baan Table
Simply use the zoom option, then search the table description or code
Finding and Adding Fields
Using this graphical tool, you can easily find the fields and add them to the query
Baan Query - Print Result
You can easily set the ranges and print
Customizing the print form
You can save different field values using Saving Defaults
Save Defaults sets the fixed “where” statement of the Query
Customizing the print form
Remove Fields from print form
Customizing the print form
You can change a field’s description and add a Zoom session
Adding fields from another table
Add Item Group Description, change title and change its position
Multiple Tables in same query
Queries can be built using multiple tables. You just need to link
them with the easy to use “table linker”
Sorting your Output
You can have 4 levels of sorting
Working with the Output
You can per-define your output device
Integrating with B2Win and B2Email
If you use B2Win and B2Email, you can automatically
format the output in Excel format and Email it by
setting the device and output file
More on using B2Win
If you use B2Win and B2Email, you can automatically
format the output in Excel format and Email it by
setting the device and output file
Running Wide Reports
In order to overcome the limitation of 255 characters
in Baan, use device type “Wide”. You can even write
a query that includes all fields from a certain table
Automation of Queries
By defining the output device and hiding the print
form, Baan Query Tool does not require any input
and can run in a job
Run-Only Baan Query Tool
Baan Query Tool is
a tool for power
users. For normal
users you allow
them to run queries
using a limited
interface. They can
run queries written
by other users
To receive a fully operational demo version contact us at:
[email protected]
NAZDAQ is a provider of Add-ons for Baan and Infor ERP Ln Customers. Other products from NAZDAQ
are B2Win, B2Email, Baan Mail-Merge, Baan Hot Link, B-Notified, Baan Color, and Baan Color Changer