This tutorial will cover the five key data types in Report Builder and provide a step-by-step guide on performing a simple calculation to determine the unit price after applying a discount.

This tutorial will guide you on how to retrieve Shelf information from the Maintain Stock Item module and display it in a report.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:20 Introduction
00:21–00:50  Step 1 : Open the Report in Report Builder
00:51–02:29   Step 2 : Write SQL Query
02:30–02:39  Step 3 : Save as New Report Name
02:40–02:52  Step 4 : Preview the Report

Today’s tutorial will guide you on how to use a Variable to calculate totals, such as the Total Quantity or Total Tax Amount.

In this step by step tutorial for beginner, learn how to use the string replace all function in report builder.

StringReplaceAll function which is used to replace specific text.

For this video, we’ll show how to change the report amount’s English currency word from “Cents” to “Sen”, by this end of video, you’ll have a solid understand how to use the StringReplaceAll function.

Time Stamps
00:00–00:16 Introduction
00:17–01:15   Explanation on StringReplaceAll Function
01:16–02:12   Replace English Currency Word from Cents to Sen

In this step by step tutorial for beginner, you will learn how to work with SQL queries to display data and interact with various components, including Label, Memo, RichText, Barcode and Image.

𝐋𝐚𝐛𝐞𝐥
🌟Label are normally used to display short text.
🌟In this Tutorial, we will show you how to capture shelf information using a Label Component.
🌟Label is to display the data at Text.

𝐌𝐞𝐦𝐨
🌟Memo are normally to print multiple lines of plain text in a report like Description, Description 2 and etc.
🌟In this tutorial, we will show you how to display more descriptions in plaintext using Memo Component.
🌟Memo is to display the data at ComponentName.Text

𝐑𝐢𝐜𝐡𝐓𝐞𝐱𝐭
🌟RichText is used to display formatted text in reports, such as Notes or More Descriptions.
🌟In this Tutorial, we will show you how to capture Maintain Stock Item Note to display using a RichText Component.
🌟RichText is to display the data in ComponentName.RichText

𝐁𝐚𝐫𝐜𝐨𝐝𝐞
🌟Barcodes render data in machine-readable formats for inventory tracking and scanning.
🌟In this Tutorial, we will show you how to capture Maintain Stock Item Barcode to display using a Barcode Component.
🌟BarCode is to display the data in ComponentName.Data

𝐈𝐦𝐚𝐠𝐞
🌟Image is used to display bitmaps and Windows metafiles in reports.
🌟In this Tutorial, we will show you how to capture Maintain Stock Item Image to display using a Image Component.
🌟Image is to display the data in ComponentName.Picture

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:11  Introduction
00:12–01:06   Label
01:07– 02:07 Memo
02:08–02:53  RichText
02:54–03:43  Barcode
03:44–04:22  Image

In this step by step tutorial for beginner, learn how to retrieve the available pipeline from the RTM Report.

The available pipeline allows you to extract report data from an existing report table and reform using SQL language. This includes action like sorting column or grouping as a new pipeline tailored to your specific needs.

In today’s tutorial, we’ll teach you on sorting invoice reports by delivery date and item code, such as arranging invoices from the earliest to the latest. By default, reports display data in the order they were entered.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:36 Introduction
00:37–01:03  Declaration Variable
01:04–01:51    Procedure GlobalOnCreate
01:52–01:55    Procedure ReportBeforePrint
01:56–03:03   LocalSQLSelect
03:04–03:07  SetDataPipelineFieldLink(Optional Step)
03:08–03:25  Example of Data Pipeline FieldLink is not required
03:26–05:31   Example of How to set Data PipelineFieldLink
05:32–05:46  Result

In this step by step tutorial for beginner, we’ll show you how to get Data directly from the database in RTM Report. This approach is similar to using the Available Pipeline. If you’re not familiar with the Available Pipeline, refer to    • Report Builder (RTM) – Get Data From Available Pipeline

𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰 𝐟𝐨𝐫 𝐆𝐞𝐭 𝐃𝐚𝐭𝐚 𝐟𝐫𝐨𝐦 𝐀𝐯𝐚𝐢𝐥𝐚𝐛𝐥𝐞 𝐏𝐢𝐩𝐞𝐥𝐢𝐧𝐞 𝐯𝐬 𝐆𝐞𝐭 𝐃𝐚𝐭𝐚 𝐝𝐢𝐫𝐞𝐜𝐭𝐥𝐲 𝐟𝐫𝐨𝐦 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞
Before moving forward, let’s quickly review the difference between using the Get Data from Available Pipeline vs Getting Data Directly from the Database.
The Available Pipeline retrieves data from a predefined data pipeline within the report table, such as sorting by delivery date or item code.
In contrast, Getting Data Directly from the Database gets data directly from SQL table, often using fields like Code to track additional details. This method is ideal for retrieving information not included in the predefined pipeline, such as batch details from Maintain Batch or BOM components in stock items etc.

In today’s tutorial, we’ll show you 𝐡𝐨𝐰 𝐭𝐨 𝐝𝐢𝐬𝐩𝐥𝐚𝐲 𝐭𝐡𝐞 𝐬𝐭𝐨𝐜𝐤 𝐛𝐚𝐭𝐜𝐡 𝐞𝐱𝐩𝐢𝐫𝐚𝐭𝐢𝐨𝐧 𝐝𝐚𝐭𝐞 𝐢𝐧 𝐭𝐡𝐞 𝐒𝐚𝐥𝐞𝐬 𝐈𝐧𝐯𝐨𝐢𝐜𝐞 𝐑𝐞𝐩𝐨𝐫𝐭 using the Get Data Directly from Database method.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:14 Introduction
00:15–00:44 Overview for Get Data from Available Pipeline vs Get Data directly from Database
00:45–00:52 Get Maintain Batch Table directly from SQL Database
00:53–01:13 Declaration Variable
01:14–01:37 Procedure GlobalOnCreate
01:38–02:22 Procedure ReportBeforePrint
02:23–03:49 Set DataPipelineFieldLink
03:50–04:08 Result

In this step by step tutorial for beginner, learn how to use the DateTimeToString function in report builder.

DateTimeToString function used to convert a date and time value into a string format for use in SQL queries.

For this video, we’ll demonstrate how to use this function to capture the total outstanding invoice amount for a customer up to Sales Invoice Date.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:20 Introduction
00:21–00:44 Step 1 : Declaration Variable
00:45–01:11 Step 2 : Explanation on DateTimeToString Function
01:12–02:08 Step 3 : Construct SQL Queries
02:09–02:48 Step 4 : Retrieve Query Results

In this step by step tutorial for beginner, learn how to create a Driver Commission Report for the Month in Sales Invoice Listing.

This report calculates the commission rate as long as the invoice is created, with no payment required. The driver commission is calculated per trip, and each item will have its own commission rate.

Summarize the information as below :
Location as the Driver Name,
Commission Rate from Maintain Stock Item,
Formula calculate the commission = Commission Rate x Quantity.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:32 Introduction
00:33–01:26 Step 1 : Create DIY Field & Brief on Default Sorting
01:27–01:58 Step 2 : Create Available Pipeline – Sort by Location
03:57–05:06 Step 3 : Change Report Data Pipeline to newly created pipeline
05:07–05:30 Step 4 : Set Group by Location Custom Field
05:31–06:53 Step 5 : Adjust Component Position and Add a New Label
06:54–07:29 Step 6 : use Variable capture Due Date from Customer Invoice
07:30–10:02 Step 7 : Commission Rate Calculation
10:03–10:34 Step 8 : Variable Calculation Sequence
10:35–11:03 Step 9 : Use DBCalc to Sum Up Field
11:04–13:02 Step 10 : Create Available Pipeline – Capture Description from Document_Location

In this step by step tutorial for beginner, you’ll learn about the commonly used components for designing reports and how to create a simple Sales Invoice format.

💎Understanding Report Object Toolbar
There are 3 main toolbars: Standard Components Toolbar, Data Components Toolbar, and Advanced Components Toolbar.

💎Understanding Report Structure
✨Header appears at the top of every page.
✨Group Header appears at the beginning of each data group.
🌟Detail Data section is used to display all item details.
✨ Subreport inside the details section.
SubReportNormal when Merge Same Item Code is unticked
SubReportMerge when Merge Same Item Code is Ticked
✨The Group Footer functions as the grouping footer and appears only on the last page.
✨The Page Footer is displayed on every page of the report.

💎Topic 3 : Print Position and Print Count
✨ Print Position determines where the Group footer will be printed on the page.
✨ Print Count specifies how many number of item records inputs should be printed.

💎Creating an Invoice Report
Step 1 : Setup Page Size
Step 2 : Add Picture
Step 3 : Add Customer Email Address
Step 4 : Add Notes
Step 5 : Add Sum of Quantity
Step 6 : Center Object Horizontally in Band
Step 7 : Select Multiple Objects
Step 8 : Save and Preview the Report

💎Alignment Toolbar
Align Left moves all objects to the left edge of the first object
Align Middle lines them up by their horizontal centers
Align Right moves them to the right edge
Align Top places objects at the top edge of the first object
Align Center lines them up by their vertical centers
Align Bottom places them at the bottom edge
Center Horizontally in Band place object in middle section
Center Vertically in Band place the object for top-to-bottom alignment.
Shrink/Grow Width adjusts the width of the selected objects to match the first selected object
Shrink/Grow Height adjusts the height of the selected objects to match the first selected object.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00-00:15 Introduction
00:16-02:31 Topic 1 : Understand Report Object Toolbar
02:32-03:37 Topic 2 : Understand Report Structure Band
03:38-03:45 Topic 3 : Print Position and Print Count
03:46-04:07 Topic 3 : Print Position
04:07-04:26 Topic 3 : Print Count
04:27-04:52 Topic 4 : Creating an Invoice Report
04:53-05:11 Topic 4 Step 1 : Setup Page Size
05:12-05:37 Topic 4 Step 2 : Add Picture
05:38-06:07 Topic 4 Step 3 : Add Customer Email Address
06:08-06:26 Topic 4 Step 4 : Add Notes
06:27-07:25 Topic 4 Step 5 : Add Sum of Quantity
07:26-08:19 Topic 5 :Alignment Toolbar
08:20-08:35 Topic 4 Step 6 : Center Object Horizontally in Band
08:36-08:55 Topic 4 Step 7 : Select Multiple Object
08:56-09:12 Topic 4 Step 8 : Save and Preview the Report

In this step by step tutorial for beginner, you’ll learn about the commonly used components for designing reports and how to create a simple Sales Invoice format.

💎Understanding Report Object Toolbar
The Fast Report Designer represents reports as a collection of schematic pages. Objects are placed anywhere on the report pages and are used to define the report’s appearance and to display various information, such as text and graphics.

💎Understanding Bands
Bands are one of the most important concepts in Fast Report.
✨The Group Header is a grouping header that prints on every page.
✨The Master Data represents the main dataset of the report.
🌟The Detail Data section is used to display all item details.
✨The Group Footer functions as the grouping footer and appears only on the last page.
✨The Page Footer is displayed on every page of the report.

💎Print position, Stop position and Print count
✨ Print Position determines where the Group footer will be printed on the page.
✨ Stop Position defines where printing should stop, detail will stop at the input value.
✨ Print Count specifies how many number of item records inputs should be printed.

💎Creating a Invoice Report
Step 1 : Choose the appropriate report
Step 2: Add a Picture.
Step 3: Add Customer Email Address.
Step 4: Add a Note.
Step 5: Add a Sum of Quantity.
Step 6: Draw a Line for Better Formatting.
Step 7: Center Objects Horizontally in the Band.
Step 8: Align Objects.
Step 9: Save and Preview the Report.

💎 Alignment Toolbar
✨ Align Left aligns the left edges of all selected objects to the first selected object.
✨ Align Middle aligns the horizontal centers of all selected objects to the first selected object.
✨ Align Right aligns the right edges of all selected objects to the first selected object.
✨ Align Top aligns the top edges of all selected objects to the first selected object.
✨ Align Centre aligns the vertical centers of all selected objects to the first selected object.
✨ Align Bottom aligns the bottom edges of all selected objects to the first selected object.
✨ Space Horizontally distributes the selected objects evenly along the horizontal axis.
✨ Space Vertically distributes the selected objects evenly along the vertical axis.
✨ Centre Horizontally centers each selected object individually within its horizontal band.
✨ Centre Vertically centers each selected object individually within its vertical band.
✨ Shrink/Grow Width adjusts the width of all selected objects to match the first selected object.
✨ Shrink/Grow Height adjusts the height of all selected objects to match the first selected object.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:15 Introduction
00:16–02:07 Part 1 : Understanding Report Object Toolbar
02:08–03:10 Part 2 : Understanding Bands
03:11–04:53 Part 3 : Print Position, Stop Position and Print Count
04:54–05:07 Part 4 : Creating a Invoice Report
05:08–05:28 Part 4 – Step 1 : Choose the Appropriate Report
05:29–05:57 Part 4 – Step 2 : Add a Picture
05:58–06:26 Part 4 – Step 3 : Add Customer Email Address
06:27–06:54 Part 4 – Step 4 : Add a Note
06:55–07:20 Part 4 – Step 5 : Add Sum of Quantity
07:21–07:35 Part 4 – Step 6 : Draw a Line for Better Formatting
07:36–08:52 Alignment Toolbar
08:53–09:12 Part 4 – Step 7 : Center Objects Horizontally in the Band
09:13–09:37 Part 4 – Step 8 : Align Objects
09:38–09:54 Part 4 – Step 9 : Save and Preview the Report

In this step by step tutorial for beginner, learn how to add a simple calculation using a Memo to your FR3 report. Specifically, we’ll focus on calculating the unit price after applying a discount.

Formula to calculating the Net Unit price = Amount / Qty

In this step by step tutorial for beginner, learn how to use the FormatDateTime function in fr3 Report, which is used to convert a date value into a string format for use in SQL queries.

For this video, we’ll demonstrate how to use this function to capture the total outstanding invoice amount for a customer up to Sales Invoice Date.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:22 Introduction
00:23–00:33 Step 1 : Declaration Variable
00:34–01:06 Step 2 : Explanation on FormatDateTime Function
01:07–01:52 Step 3 : Construct the SQL Query
01:53–02:33 Step 4 : AddDataset and LinkTo Methods
02:34–02:53 Result