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_examples

Table of Contents

1

Basic Use

This is the basic structure of a custom report. This report lists order lines of tickets.

I'm adding quantity column to report.

I'm adding quantity summary.

Filtering

I'll filter items by Menu Item Group. I'll use (MG=x) expression for that. This report will display only Breakfast items.

I'll append another report to display Misc Items. To separate reports from each other I used >Label syntax to add bold lines between reports.

Grouping

I can append unlimited number of reports to display more categories. However it will be hard to prepare a report if I have more menu categories. I can use “Parameter List” feature instead of appending a report for each filter value I need. I'll prepare same report by using a parameter list.

You'll probably want all Menu Categories that exists in that report. Instead of hardcoding all groups one by one I can use another report tag to fetch these values. I'll replace @Breakfast,Misc line with a report tag so my parameter list will generate automatically.

Still same report generates but there is no hardcoded value so as we add new menu item groups to SambaPOS they'll appear in report automatically.

Finally I want to execute {REPORT ORDER DETAILS:O.ItemGroup.asc::,} tag individually to show what it exactly returns.

That generates a comma separated list of Menu Item groups that appears in the report. Being able to get menu groups that exists in report is a great feature so if we normally have a “Pizza” group but it does not exists in the report a blank section will not appear for it.

custom_report_examples.txt · Last modified: 2019/04/19 03:24 by 93.179.68.108