REPORTING

One of the most important requirements for an enterprise system is the ability to quickly create reports. Axxerion has a large number of standard reports for each module. It is also possible to create your own reports and dashboards. The reports can be viewed directly in the browser and can be converted to PDF so that they can be downloaded and printed. It is also possible to import a report in Microsoft Excel for further analysis.

Filters: Multiple filters with fields from different objects can be created for a report. You can use operators, default values and dynamic variables such as 'last week', 'current user' or 'my department'.

Subtotals: The results can be grouped by multiple columns. You can specify per column if a sub total should be displayed and if the sub total should be calculated by taking the sum or average.

Formulas: You can create columns with calculated fields by using expressions, formulas and conditional statements. Standard functions are supported such as for rounding, minimum/maximum calculation, time conversions and formatting.

Charts: Results can be displayed as lists or charts. You can select various chart types such as line chart, bar chart, pie chart, time chart or meter. The charts can be applied to columns with formulas.

Dashboard: You can create digital dashboards with charts, meters and lists. Dashboards can quickly be modified and you can design a custom digital dashboard for various types of objects such as properties, projects or assets.

Forms: You can design your own forms with Microsoft Word. This can for instance be used for invoices, purchase orders or reservations.

EXAMPLES

Reports
Dashboard
Word templates

FEATURES

	Default values Current date Current user Last week This year Next month My location		Formatting Dates Integers Floats Decimals Day name Month name		Date formulas workHours addDate year month day hour
	Filters Equals Contains Less Greater Not empty Empty		Graphs Pie chart Bar chart Line chart Time/value Meter Point chart		Grouping and sorting sort total subtotal average min max
	Generic methods isEmpty print lookup image set enum		Text formulas concat left right middle indexOf extract		Integration LDAP Intranet FTP in/out Email in/out Stylesheets Web services