About Report Builder

Report Builder is a comprehensive reporting tool. It provides a powerful, yet user-friendly data reporting and analysis tool, allowing you to see a snapshot of your data across various categories. This is a complete report creation facility, where you create reports by selecting which fields to display and applying report parameters, filters, and conditions, etc.

Using Report Builder you can:

• Create reports with tables, matrices, charts, or free-form areas. Start designing your report by using the Table, Matrix, or Chart Wizard. Choose a data source connection, drag and drop fields to create a dataset query, select a layout and style, and customize your report any way you want.
• Jump start your report authoring by using predefined report parts and shared datasets.
• Modify your data by filtering, grouping and sorting data, or by adding formulas or expressions.
• Change the appearance of your report by adding text boxes, colouring, images, or conditional formatting.
• Add interactive features, such as interactive sorting, drill-through reports, and toggling the visibility of report items.
• Run the report to preview your changes. Toggle between design view and preview.
• Save the report to any location, where you can manage it and share it with others.
• Export the report as a different file type, such as a TIFF, PDF, Excel, Word, or HTML file.

Report models

Models are pre-defined fields that have been collated by Advanced to use in reports alongside ALB. These allow you to build basic reports without having to understand the entire database schema. They are shipped as standard and installed with Report Builder. Alternatively, if you know how to use SQL, you can write your own code to create custom reports.