Baan Query Tool Version 2 6 Easily retrieve

  • Slides: 20
Download presentation
Baan Query Tool Version 2. 6 Easily retrieve data from the Baan database

Baan Query Tool Version 2. 6 Easily retrieve data from the Baan database

Current Query Tools Status n n n Difficult to configure and install Difficult to

Current Query Tools Status n n n Difficult to configure and install Difficult to use Time consuming Expensive to configure Expensive to run

Baan Query Tool n n n Quick Installation: Load few sessions and all Baan

Baan Query Tool n n n 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 n n n Baan Query Tool is fully integrated in Baan.

Baan Query Tool n n n 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

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

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

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

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 Remove Fields from print form

Customizing the print form You can change a field’s description and add a Zoom

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

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

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

Sorting your Output You can have 4 levels of sorting

Working with the Output You can per-define your output device

Working with the Output You can per-define your output device

Integrating with B 2 Win and B 2 Email If you use B 2

Integrating with B 2 Win and B 2 Email If you use B 2 Win and B 2 Email, you can automatically format the output in Excel format and Email it by setting the device and output file

More on using B 2 Win If you use B 2 Win and B

More on using B 2 Win If you use B 2 Win and B 2 Email, 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,

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

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 is a tool for power users. For normal users you

Run-Only 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: info@nazdaq-it. com NAZDAQ is

To receive a fully operational demo version contact us at: [email protected] com NAZDAQ is a provider of Add-ons for Baan and Infor ERP Ln Customers. Other products from NAZDAQ are B 2 Win, B 2 Email, Baan Mail-Merge, Baan Hot Link, B-Notified, Baan Color, and Baan Color Changer