====== Create Custom Reports ======
----

**Xcalibur W** collects and centrally stores data from devices in its database. While the information is available within the software's built-in views, it may not be in the desired format.\\
**Reporting Services** offers a means to select and export device data using **Layouts** and **Filters**. The output of these data can be CSV, XML and JSON.


===== Columns Layout =====
----

A **Layout** is an ordered list of items that defines the structure of data that are intended to be extracted from the database. There are five default layouts provided as templates. They cannot be edited or deleted.

{{ custom_report:1.png }}

Add custom layouts by clicking the {{icone:add.png}} button. This requires an advanced knowledge of the system. 

{{ custom_report:2.png }}



===== Filters =====
----

A Filter is an ordered list of criteria used to refine the data extracted from the database. There are five default filters provided as templates. They cannot be edited or deleted.

{{ custom_report:3.png }}

Add custom filters by clicking the {{icone:add.Png}} button. This requires an advanced knowledge of the system.

{{ custom_report:4.png }}


|{{:tip.png |}} Refer to the [[:reporting_services:advanced_reporting_with_webservices|Advanced Reporting]] section to get a better understanding of Layout and Filter syntax.|
===== File Export =====
----

To generate an output file in the desired format, select the required Layout and/or Filter and the export format. Provide a file name and save location, and then click **Export**.

By default, the output is restricted to enrolled devices. However, by deselecting the check box, unenrolled devices may be added.

{{ custom_report:5.png }}

After clicking **Export**, you will be prompted to open or save the file.