View Report – New Update in Data Entry Grid Window

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:

Sale Bill-View Report

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.

View Report Window

Grid Report Configuration

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

Set Columns Dimension - Measure Wise

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


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.

Set Order - Grid Report Configuration

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:

Filter option -- Grid Report Configuration

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.


Was this article helpful?

No 0