# Create an Analyzer report

Pentaho Analyzer automatically fetches data in real time as you add and remove fields, so you may find it easier to build a report with the **Auto Refresh** feature turned off. Then you can design your report layout first, including calculations and filtering, without querying the database automatically after each change. Just click the auto refresh icon in the tool bar to toggle **Auto Refresh** on or off, or you can click the **Refresh Report** button at any time.

To create a new report, perform the following steps:

1. From User Console Home, click **Create New**, then **Analysis Report**.
2. Choose a data source for the report from the Select Data Source dialog box, then click **OK**.
3. From the **Available Fields** pane on the left, click and drag an object to the **Rows** or **Columns** area in the **Layout** panel.

   The data row or column appears in the table workspace.

   **Note:** You can remove an object from a row or column by dragging it from the **Layout** panel back to the **Available Fields** list.
4. In the list of fields, click and drag a measure to the **Measures** area in the **Layout** pane.

   The measure appears as a column in the table workspace.
5. If you want to rename or reformat your columns, right-click a column and choose **Column Name** and **Format** from the menu.

   The Edit Column window appears.

   **Note:** You can also sort the data in your columns by clicking and choosing a sort-order from the drop-down menu.
6. Choose a format from the **Format** drop-down box, or choose a [visualization](/pba/9.3-analytics/pentaho-analyzer-cp/creating-analyzer-reports/visualizations-for-analyzer.md) from the drop-down menu. Click **Refresh Report** if you need to, then click **OK**.
7. Click **Save As**. Type a file name for your report and choose a location to save it in, then click **OK**.

The new Analyzer report is created and saved in a location of your choice.


---

# 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.pentaho.com/pba/9.3-analytics/pentaho-analyzer-cp/creating-analyzer-reports/create-an-analyzer-report.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.