B2Report - B2Win Suite

Create custom ERP reports without having to write SQL

Learn More

Create custom operations and financial reports
All visual & easy-to-use
Made for everyone (team members and management levels)

Query your database and create meaningful reports with ease. Take control of the big picture enabling you to make more informed decisions.

Fully integrated with B2Win Suite Output Apps

Watch DEMO VIDEO

B2Report is a powerful enterprise reporting solution that combines a user-friendly visual query builder, with the power of Excel.

It enables you to easily bring data, directly from your Infor LN, Baan ERP or any other database, to design and create meaningful reports without having to write SQL.

BENEFITS

Data on Demand

The data you need, when you need it, the way you want it

Reports for All

Meets everyone’s reporting needs (executives, managers, and regular users…)

Query for All

Build your query visually, without writing SQL

Secured

Your data is secured with a multi-level ACL permissions system

HIGHLIGHTS

Create Query Visually

Our query builder allows you to easily browse or search DB tables/fields, and visually create SQL queries by dragging the tables into a big canvas that allows you to visualize your data, join tables together and choose the fields you want.

Search for tables and fields by code or description
All Join Types
Data Dictionary for tables and fields, enumerated fields (Infor LN / Baan IV / Baan V)
Multi-company DB (Infor LN / Baan IV / Baan V)
Group by / Aggregation
Virtual Fields
Conditions (Query and formula functions)
Sorting
ACL permissions per DB, query and table for increased security

Prepare, Clean and Enrich your Data

B2Report allows you to create structured and meaningful spreadsheets by simply dragging the data that you want, clean the data, and enrich it with calculated fields. Design multiple data views for all your operational and financial activities, see the full picture, and make better decisions.

Rearranging of columns
Header renaming
Splitting of columns
Data types
Inserting of calculated columns
Hiding of columns
Removing leading zeros and trailing spaces
Sorting
Multiple designs or views
Input-form (GUI) Builder
Zoom-to Tables
ACL permissions per design

Reports for all

Team members across all departments (sales, operations, finance…) and management levels can all easily have access all or some of the reports. They can browse, search, and generate reports according to their user permissions.

Global Reports Menu for all departments with advanced ACL permission management per report, user, group…etc
Add to Favorites, which allows better organisation and easier access to important reports i.e. the CEO or CFO can add their own reports to Favorites for easy and immediate access to important data. The developers can add their own reports for easier management and development work.
Uncomplicated report deployment, with development and production environments

Examples

Full integration with Output Apps and Excel

B2Report is fully integrated with B2Win Suite’s Output App and Excel Templates for more flexibility, accessibility and further functionality, format transformation, report management, advanced distribution and more.

Automate the Generation of Reports to Excel and use it to generate graphs, charts, and tables for an insightful data presentation with 1-Click