Components of a Xilnex Web Report

Components of a Xilnex Web Report

Select any report from the list to open it. We will use the Daily Sales Item report as an example.

1. Report Fields

 Report fields are parameters that are used to define the scope of a report. They determine:
  1. Where: The location or outlet
  2. When: A specific date or date range
  3. What conditions: Document status or item grouping (category, group, brand etc)
The table below describes each parameter for the sample report.

2. Optional Fields

Optional fields provide additional settings specific to the current report. These settings may:
  1. Change how values are generated (using an alternative method), or
  2. Include additional report details that are not part of the default output.
IdeaInfo
Example: If the "Generate business session info" setting is enabled, sales values in the report will be generated based on the business date instead of the sales date.

3. Advanced Search 

Advanced search allows users to apply additional filters before generating a report. This feature enables precise control over the output by defining specific attributes to include in the report. Each General Report includes default data fields that can be organized into different areas. The placement of these fields determines how the report is structured:
  1. Data Area: Rightmost area of the report. Used for numeric fields, like quantity, price and cost amounts.
  2. Row Area: Leftmost area of the report. Used for text or header fields such as document ID, document status, date, outlet and so on.
  3. Filter Area: Holds fields removed from the Data or Row areas. Fields placed here will not appear in the generated report.
  4. Column Area: Used to insert fields as headers for the Data Area. When the report is generated, each value in the Column Area creates its own column for the corresponding Data Area values.
5. Advance Settings

The Advance Settings section provides extended options to control how data is calculated, summarized, and presented.
This section is collapsed by default and can be accessed by clicking the section.

a. Enable Value Sorting
  1. Only applies to the last column of the Data Area. 
  2. Sorts the values of the rightmost column from the smallest to the largest.
  3. If any of the fields in the Data Area is rearranged, the report must be re-run to refresh results.
b. Show/Hide Total
  1. These functions control whether totals and grand totals appear in the report. 
  2. An example of what the report will look like when these settings are all disabled is shown below. The report looks much cleaner, but without any summary of the results.
  3. These settings are enabled by default for all reports. 
c. Show Column Grand Total
  • Displays a single grand total at the end of the columns, when there is more than 1 data group (highlighted in red) in the Data Area.
  • The example below shows the report displayed when only the "Show Column Grand Total" setting is enabled. 
d. Show Column Totals
  1. Displays the subtotals for each data group with the condition that there is more than 1 column (highlighted in red) within the data group.
  2. The example below shows the report displayed when only the "Show Column Totals" setting is enabled.
e. Show Row Grand Total
  • Displays a single grand total for each column, when multiple rows exist in the row area.
  • The example below shows the report displayed when only the "Show Row Grand Totals" setting is enabled.


f.  Show Row Totals
  1. Displays subtotals for each row group with the condition that there are multiple rows for that group.
  2. The example below shows the report displayed when only the "Show Row Totals" setting is enabled.|
g. Summary Display Type
  1. Allows users to display data in different comparative or percentage formats.
  2. Condition: The report must be generated first before this feature is usable.
Steps to use this feature:
  1. Select the "Field" and "Display Type".
  2. Then click the "Show More Fields" button.

  3. A new field will be available. Drag the field into the Data Area. 

  4. Once the report is generated, the data for this new field will be shown as below.

  5. A brief description of the available display types are as follows:
    Display Type
    Description
    Percent of Column
    Shows the result of the [selected field] ÷ [total of the row].
    Percent of Row
    Shows the result of the [selected field] ÷ [total of the column].
    Percent of Column Grand Total
    Shows the result of the [selected field] ÷ [grand total of the row].
    Percent of Row Grand Total
    Shows the result of the [selected field] ÷ [grand total of the column].
    Percent of Grand Total
    Shows the result of the [selected field] ÷ [grand total of the row and column].
h. Summary Type
  1. Defines how numeric data is aggregated in the report.
  2. Condition: The report must be generated first before this feature is usable.
Steps to use this feature:
  1. Select the "Field" and "Summary Type".
  2. Then click the "Show More Fields" button. 
  3. A new field will be available. Drag the field into the Data Area.

  4. Once the report is generated, the data for this new field will be shown as below.

i. Top Value Count
  1. Highlights the top n results based on a selected field.
  2. Condition: The report must be generated first before this feature is usable.
Steps to use this feature:
  1. Select the "Field" and "Top Value Number".
  2. Ensure the field is present in the table. If it is not, please add the field from the "Show More Field" list.
  3. Before setting applied: All records will are displayed.

  4. After setting applied: Only the top 2 records of the field selected will be displayed.

    • Related Articles

    • Web Report Types in Xilnex

      Report Types The Web Report offers three types of reports to suit different business needs: General Reports, Defined Reports, and Custom Reports. Each type provides varying levels of flexibility and customization. General Reports General Reports are ...

    • Configuring Web Report Access

      How to Configure Web Report Access? 1. Click on "System Configuration" on the left side panel. 2. Scroll down to find "User roles permission" under Users & Roles section. 3. Click on "All permission". 4. Click on "More", then select "Menu (Xilnex ...

    • Getting Started with Xilnex Web Report

      Product Introduction Web Report is a centralized reporting tool that enables businesses to generate insightful reports based on the transaction data captured across various Xilnex products, including Xilnex Classic, Live Order, F&B Go, Xilnex ...

    • Recent Articles

    • How to Stop Xilnex E-Invoicing

      Scenarios Requiring Xilnex E-Invoicing Deactivation Deactivate Xilnex E-Invoicing when a business falls below mandatory thresholds or ceases operations, ensuring compliance with IRBM guidelines while avoiding unnecessary module activity. This ...

    • Xilnex E-Invoicing Document Split

      Type Descriptions Product Xilnex E-Invoicing New Features E-Invoice Document Splitting Document Splitting Function Type Toggle Configuration E-Invoice Settings Required DB Upgrade No Release Date 13 August 2025 Background When a generated payload ...

    • Connecting KDS 2.0 to POS

      Xilnex ClassicPOS Important Notice: As of now, in order to use KDS2.0, Classic POS version must be at least version 2.16 July 2025 and above. 1. In System Configuration > select Device Configuration > under This Machine > look for Kitchen Display ...

    • Congiure a Client KDS - Connect to a Host KDS

      KDS Client A KDS Client Device in Xilnex KDS 2.0 is a display screen (such as a tablet, monitor, or smart TV) located at a specific kitchen station (e.g., Grill, Bar, or Cold Station). Its primary function is to receive and display orders sent from ...

    • Configure A Host KDS Device

      A Host KDS in Xilnex KDS 2.0 is the designated central hub device responsible for synchronizing and managing the entire kitchen network. It acts as the primary authority, ensuring that all orders from the POS system are correctly distributed to ...

    • Popular Articles

    • Basic - How to create a voucher-coupon

      Voucher and coupon definition Voucher can be generated in bulk and can be used once Coupon can only be created one at a time (reusable code) and can be use multiple times Pre-voucher / coupon setup There are 2 things need to be prepared before we can ...

    • Basic - How to change custom cost to another branch that don’t have custom cost

      Change custom cost to another branch that don’t have custom cost 1. Get the item list from the location with custom cost (Item Code, Name, Custom Cost) 2. Make sure the Show Location Price are selected 3. Export the item list in Excel 4. The file ...

    • Intermediate - How to Bill & Post to Sales from Transfer Note

      1.0 Purpose A bill is required from transfer note when an inventory transfer involves financial transactions, cost allocation, or compliance with tax and accounting regulations. It is used when stock is moved between outlets that operate as separate ...

    • Importing Usernames in Xilnex Portal

      What is User Import? User Import allows you to add, update, or manage multiple users in bulk rather than handling them one by one. This feature is especially useful for onboarding new employees, migrating data, or making large-scale updates to user ...

    • Configuring Web Report Access

      How to Configure Web Report Access? 1. Click on "System Configuration" on the left side panel. 2. Scroll down to find "User roles permission" under Users & Roles section. 3. Click on "All permission". 4. Click on "More", then select "Menu (Xilnex ...