B2Report is a visual report builder. It enables you to easily bring data, directly from your ERP or any other business application, to design and create meaningful reports for your operational and financial needs, and much more.
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
Highly 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
- Conditions (Query and formula functions)
- Sorting
- ACL permissions per DB, query and table for increased security
Design Reports Visually
B2Report also allows you to create structured and meaningful spreadsheets by simply dragging all, or a selection of, query fields. This allows you to design multiple views of your data in order to answer your business needs, such as operational and financial.
- 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
B2Reports is fully integrated with B2Win Suite’s Output App and Excel Templates for more flexibility, accessibility and further functionality, such as report formats, graphs, pivot tables, management, and distribution.
HOW IT WORKS
Expand and Build
The API makes it easy for customer and developers to create applications and interface between your business system and B2Report.