# 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-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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.alemba.com/asm-hermes/use-asm/using-asm-core/getting-started/searching-for-items/creating-reporting-views-from-search-results.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.