> For the complete documentation index, see [llms.txt](https://docs.alemba.com/asm/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.alemba.com/asm/asm-hermes/use-asm/using-asm-core/getting-started/searching-for-items/creating-reporting-views-from-search-results.md).

# Creating Reporting Views from Search Results

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

<figure><img src="/files/AatVw2qhxnyIUGz5uaeN" 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://docs.alemba.com/asm/asm-hermes/use-asm/using-asm-core/getting-started/searching-for-items/www.alemba.help) to configure the database accounts and Schemas to support this feature.