> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-version-release-notes/december-2018/reports/view-report-new-update-in-data-entry-grid-window.md).

# View Report – New Update in Data Entry Grid Window

**YouTube:** [View Report – New Update in Data Entry Grid Window](https://youtu.be/donB49VJ_1A)

### View Report option added in the Data Entry Grid window

Let us take an example of Sale Bill window. You can see a new icon added as shown in the figure below:

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FvdRB7P8RiULoBIz1G5vL%2Fimage.png?alt=media&amp;token=f2a158b6-e6cb-4eb8-98c9-fe665d23042b" alt=""><figcaption></figcaption></figure>

This option enables you to generate the side-by-side report for the items you sold. You can also keep track of the number of items you sold. It enables you to control the list of columns that you want to display in the report.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FWNtQDAZ8VvDbF78Ux1uu%2Fimage.png?alt=media&amp;token=68479175-f51d-43c4-a5e3-a2478e60664c" alt=""><figcaption></figcaption></figure>

### Grid Report Configuration

You can set up the configuration of the report in this window.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FTWTaOdja2VUBXSBDiHRZ%2Fimage.png?alt=media&amp;token=1da5641e-eefe-4ebc-b869-efb2802d5522" alt=""><figcaption></figcaption></figure>

1\. In the Dimension box, you can include the columns with simple values such as Item name, company name, etc. In the Measure box, you can include the columns that accept numerical values & can calculate their total like Total Quantity, Amount, etc.

&#x20;Note: You can see that Company Name exist in Grid Report Configuration but not in Sale Bill Window. The column is hidden because of ‘Do Not Show Column’ option included in Set Column Attributes window. It is not necessary that Company name must get displayed in the Sale Bill Window in order to include in the report. You can include any column by using these filters in Grid Report Configuration.

2\. In the “Set Order” box, you can include the columns to arrange them in Ascending or Descending order.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F5CxxifYWmRmSSIjfR9xC%2Fimage.png?alt=media&amp;token=3d445f14-c170-4ae6-83db-ee69862acffe" alt=""><figcaption></figcaption></figure>

3\. Let’s assume that you want to display items with quantity less than 5. For this, you can use the data filter and the output filter option. Write the code as explained in the example and press the “Save” button. The figure below will give you clear sight this feature:

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FkeYbpGRxRTBTdw49lHhA%2Fimage.png?alt=media&amp;token=2859ab6e-387b-4a21-860f-1b41f9ca68ca" alt=""><figcaption></figcaption></figure>

4\. Tick the “Skip Last Row From Grid” option to eliminate empty rows from the list. When you tick “Display Totals” options, the total of every column with numerical values will get calculated and displayed in blue color.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FunzQEcBEvMLN62ieJnra%2Fimage.png?alt=media&amp;token=1dca0e62-0701-48fd-8c1c-55aa4260345d" alt=""><figcaption></figcaption></figure>

**Note:** You can see that Company Name exist in Grid Report Configuration but not in Sale Bill Window. The column is hidden because of ‘Do Not Show Column’ option included in Set Column Attributes window. It is not necessary that Company name must get displayed in the Sale Bill Window in order to include in the report. You can include any column by using these filters in Grid Report Configuration.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://kb.logicerp.com/logic-erp-version-release-notes/december-2018/reports/view-report-new-update-in-data-entry-grid-window.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
