SAP Business One – Crystal Reporting

SAP Business One – Reporting

Crystal Reports, owned by SAP, is the default reporting tool for many Applications throughout the world and is provided at no cost and is included for SAP Business One.

 

Firstly, Crystal Reports connects to the SAP Business One database on both MS-SQL and SAP HANA platform.

 

So what would you use Crystal Reports for SAP Business One to typically create for the business? We find this would be Tabular reports, dashboards, graphs and document layouts are typical of the type of outputs that can be generated using this industry standard reporting tool. These outputs can also be exported to PDF and other standard export formats. Reports can also be shown on the SAP Business One Mobile App. Scheduling and emailing Crystal Reports is also possible using the SAP Integration tool known as B1iF.

 

SAP Business One – Crystal Reports Features

 

Integration
Crystal Reports directly integrates with the SAP Business One application, there is an additional file menu within SAP Crystal Reports to connect, save and preview reports within SAP as shown in the screen below.

SAP Business One Crystal Report

 

Input and Selection

Standard SAP Business One input prompts can also be initiated from within Crystal Reports. In the below example, Crystal Reports is displaying the customary Business Partner prompt.

SAP Business One Business Partner Selection

 

SAP Business One Crystal Reports – Options

 

Tabular reports: Below is a screen shot of Item Sales Analysis Report. Data within the report can be sorted, grouped and highlighted to identify any anomaly.

SAP Business One Sales Analysis Report

 

SAP Business One Charts: Visual displays can be easily created using Crystal Report Chart Expert Tool.
Below, the Pie chart Sales by State, shows New South Wales (NSW) highlighted in blue as the Second Best State with 24% of the total sales statewise.

SAP Business One Graph Reporting

 

SAP Business One Dashboards: Simple real time dashboard can be designed using Crystal Reports. The screen shot below shows the Sales transactions by Item Group and Top 5 Products sold.

SAP Business One Dashboard Reporting

 

SAP Business One Document Layouts: Professional looking document layouts, such as Invoices, Customer Statements etc can be created using Crystal Reports Section and Grouping Expert tool. Below is a section of Order Confirmation Document.

SAP Business One Document Layout

 

 

SAP Business One Report Security: Crystal Report uses the SAP authorization to manage and control access to reporting information. To access a report, the User will need to be assigned authorisation. The below screen shot, the current user has no authorization to run the Item Sales Analysis Report.

SAP Business One Report Security

 

SAP Business One Customised Reports for Mobile Access: There is a check button (Visible for Mobile) option on the report setup menu, to display the report on a SAP Business One Mobile app.

SAP Business One Mobile Report Administration

 

SAP Business One Crystal Reports Scheduling and Email: Crystal Reports can be scheduled and emailed using the SAP Business One Integration Framework Tool, B1If.

SAP Business One Reports Emailed and Scheduled

 

If you are looking at SAP Business One and Crystal Reports and need assistance or have any questions please contact the Inecom Team!