The majority of business reports can be customized:
- Freely choose the columns you to include and in which order
- Add your logo, your colors, your formatting
- Add calculated columns such as financial calculations
- Add charts or pivot tables
- Create reports with multiple sheets
Customization follows these steps:
- Add new report and choose an existing report to start with
- Download the Excel template for the report and make your changes
- Upload your template and name your new report
Step 1 - Add a new report
Open the business reports page in your Wordbee Translator. Then click the Add new report link:
The following dialog opens:
Under Reference report select an existing report which you want to customize. Then type a Title and click Ok.
Although you can immediately customize the report layout from this screen, for the purpose of this tutorial, we will do it in a next step.
Your new report is now shown in the list of all reports and you can hit Create report to see if it works.
Step 2 - Customize your report
Next to your report you can see an Edit link. Click this link to open the editing dialog:
From here you can change title, description and color (of the title in the reports list). You can also delete your report from here.
But let's now focus on customizing content and layout.
Click Download Excel file to get the report template:
The template looks much as the final report but without the data. Instead it includes "placeholders" that define which data field shall be inserted in which place. Excel line #6 will be repeated for each row of data.
All you now need to do is apply your changes and then upload your new template in the dialog above.