Category: 9. Reports

Main Menu > Manage > Reports > Add Report > Add this Custom Report Template inside report. Custom Report 1 [Table 1:1,1] >Sub Row 1| Cell 1|Cell 2 Cell 3|Cell 4 This is what each template line displays. Formatting Tables When you add a Table Section all lines added under that section will appear as a table […]Read More

Adding SQL Scripts You can display result of an SQL Script in custom reports. If SQL Scripts returns a single value you can use it as a cell value. If it returns multiple values that will be formatted as a table row. In other words SQL result will be converted to a list where each […]Read More

It is possible to prepare any type of reports with SQL and display results as a Custom Report. Alternatively you can use Custom Report Tags to prepare reports. If you need more information about preparing a custom report you can review tutorial below. http://forum.sambapos.com/t/new-how-to-use-custom-reports-module-1-0/2142 Introduction Basically there are four types of tags. DETAILS TAGS These […]Read More

Here are new custom report tags implemented for V5 REPORT ENTITY DETAILS Reports details for Entities Field Description E.Id Entity Id E.EntityTypeId Entity Type Id E.Type Entity Type Name E.AccountId Account Id E.Balance Entity Balance EC.<custom field> Custom field value for <custom field> REPORT ENTITY DETAIL Does same thing with REPORT ENTITY DETAILS but this […]Read More

Creating Accounting Reports with Custom Reporting Tags Using Custom Report Tags Custom reports contain some tags useful for preparing reports easily. These tags work same as Printer Template Tags but the difference is these tags will display values from selected date range, or date range from active work period if used out of report module. […]Read More

Pivot tables are useful to create different views of data easily for better analyzing data. Preparing a Sample Report You can create a simple Orders report by using this custom report template. [Orders:1,2,1,1] >Item Group|Item|Quantity|Total {REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.Quantity,O.TotalPrice} This report will list all orders we’ve placed inside selected date range. Converting Report to a Pivot Table Pivot […]Read More

Introduction You 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. In here it is used this Custom Report Template to generate that report. [Tickets:1,1,1,1] >Ticket […]Read More

You can add custom reports inside a Custom Entity Screen by using a Custom Report Viewer Widget. After adding widget in custom entity screen click Settings context menu item to edit settings. You can select a custom report from Report Name combo box. Setting a Border for report or changing Zoom Ratio is also possible. For using Setting Mappings feature you can review Custom Report Widget […]Read More

Basic Use This is the basic structure of a custom report. This report lists order lines of tickets. Adding quantity column to report; Adding quantity summary; Filtering You can filter items by Menu Item Group. You should use (MG=x) expression for that. This report will display only Breakfast items. Another report will be added to […]Read More

1. What is Item Sales Report Based on Product Tag Groups? 2. Creating Product Tag Captions 3. Grouping Products by Tagging 4. Creating New Report 1. What is Item Sales Report Based on Product Tag Groups? Product Sales Report Based on Product Tag Group: In default SambaPOS settings Product Sales Report is created according to group […]Read More

Go to Navigation > Manage > Reports > Reports from here click on Add Report link. Name: Field to write name of report. (For example; Void and Gift Report) Page Size: Field to set page size. (In the example; 600 px) Display in Report Explorer: Activate it by selecting the box. Template: Copy the code below into template field. […]Read More

In order to create item group sales report according to ticket type, go to Manage > Reports > Reports from here click on Add Report link. Name: Field to write name of report. (For example; Item Group Sales Report – According to Ticket Type) Page Size: Field to set page size. (In the example; 500px) Display […]Read More

In this document, it will be explained how to create Open Tickets Report for SambaPOS Metrik V2. Main Menu > Manage > Reports > Reports > Add Report > In here, copy below code group and paste it into Template area of the new report as shown in the below image and then click on […]Read More

In order to create remaining balanced customers report go to Manage > Reports > Reports from here click on Add Report link. Name: Field to write name of report. (For example; Remaining Balanced Customers) Page Size: Field to set size of page. (In the example; 500px) Display in Report Explorer: Activate it by selecting the box. Template: Write Remaining […]Read More