# Creating Reporting Views from Search Results

{% hint style="info" %}
Applies to: Hermes 10.6.8.**13699** and higher
{% endhint %}

<figure><img src="https://1375663122-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhlW9jKl7dcDggHAPhNU9%2Fuploads%2F84CuRUTpBw5UAAu8vr1X%2FScreenshot%202024-03-22%20at%201.13.11%20PM.png?alt=media&#x26;token=9a3bc7d6-92ee-44ef-9f14-56fd7fd2c58d" alt=""><figcaption></figcaption></figure>

#### Using Table Views for Database Reporting in Alemba Service Manager (ASM)

Alemba Service Manager (ASM) offers the flexibility to generate reports by leveraging table views created ad-hoc. This process involves exporting search results as a view, which can then be utilized for reporting purposes.&#x20;

{% hint style="info" %}
Calculated fields such as Indicator Column and access to Custom Extension Fields require joining this View at the database level.
{% endhint %}

Creating SQL views directly against the database can significantly enhance the reporting capabilities within ASM for various entities like calls, requests, and tasks, providing a comprehensive data analysis tool.

## **To Enable this capability**&#x20;

1. Your Security role (IPK, Workflow, etc) must have Export Search View
2. You must contact [Alemba Support](https://www.alemba.help) to configure the database accounts and Schemas to support this feature.