SambaPOS

Documentation Website

User Tools

Site Tools


Sidebar

Installation

User interface

Basic concepts

  • Departments
  • Terminals
  • Users & user roles
  • Work periods
  • Tickets & orders
  • The POS menu
    • Products & product categories
    • Menus
    • Recipes
    • Product modifiers

Quick-start: setting up a (very basic) POS configuration

Advanced concepts

Customizing your POS system

Extra

Mobile Client

SambaPOS License

custom_report_table_views

Introduction

We can convert a Custom Report to a Table View for more sorting, filtering, grouping or data analyzing features. Adding # char in front of a table name converts report to a table.

This is a simple custom report that lists tickets in date range. I've used this Custom Report Template to generate that report.

  [Tickets:1,1,1,1]
  >Ticket No|Date|Time|Total Amount
  {REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,T.TotalAmount}
  

I can convert this report to a table by adding # in front of table name. So [Tickets:1,1,1,1] line becomes [#Tickets:1,1,1,1].

You can click column headers for sorting or right click on headers for advanced options.

Setting Column Types

You can see on the screen shots Total Amount column is left aligned. That means our table processes this value as a string value. We can set type of a column by using column type indicators. I'll add [C] in front of Total Amount header to format this value as Currency.

  [Tickets:1,1,1,1]
  >Ticket No|Date|Time|[C]Total Amount
  {REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,T.TotalAmount}

We can use [N] to format a column as a Numeric column. Useful for formatting non financial numbers such as quantities.

Now Total Amount column recognized as a currency column. In further sections we'll see how to enable total summary footer for that column.

Setting Table Height

In table view mode we can set a height for the table.

  [#Tickets:1,1,1,1:500]

500 means 500px height. If you do not set a value default value is 300px and if you set it as 0 table will have unlimited height. Table width is determined by report width.

Changing & Saving Table Settings

You can resize columns, change order, change grouping or change sorting. If you want to store these settings right click on table and click Save Settings command.

By clicking View Editor commands you can enable advanced editing mode. You'll find a lot of settings there.

Here are some useful settings. You can type their name on search box to find them easily.

ShowSearchPanelModeDefault-Always-NeverDisplays search panel.
ShowVerticalLinesTrue-FalseDisplays Vertical Lines or not.
ShowHorizontalLinesTrue-FalseDisplays Horizontal Lines or not.
ShowColumnHeadersTrue-FalseDisplays Column Headers or not.
ShowIndicatorTrue-FalseDisplays Row indicator.
AutoWidthTrue-FalseAutomatically fits column widths to table width.
ShowAutoFilterRowTrue-FalseDisplays excel like auto filter row to filter rows.

Formatting Total Summaries

When you enable View Editor > ShowTotalSummary setting a footer bar will appear. Right click under Total Amount column and choose Sum.

That will display the sum of Total Amount column.

Click Customize to change how sum value appears.

Custom Report Widget Settings for Table View

We can add this report as a Widget in a Custom Entity Screen. Custom Report Viewer Widget displays custom reports in entity screens.

We can use this table for advanced UI customization.

Setting Mappings

Syntax: <setting name>=<table name>.<field no>

In Setting Mappings editor you can map table column values to Custom Settings. TICKETNUMBER=Tickets.1 means we can access 1st value of Tickets table (we named it as Tickets inside report template) with [:TICKETNUMBER] tag. As 1st field is in our report template is TicketNumber, TICKETNUMBER setting becomes selected row's Ticket Number value as we navigate through rows. You can map multiple values to different settings by adding a separate line for each setting in Setting Mappings editor.

tip Field numbers are relative to report template. Changing column orders or visibility through table settings won't change field numbers.

custom_report_table_views.txt · Last modified: 2019/04/19 01:31 by 93.179.68.108