SQL Customization Report – Display Data by Different Component – E Stream MSC

SQL Customization Report – Display Data by Different Component

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:0000:11Β  Introduction
00:1201:06Β  Β Label
01:0702:07 Memo
02:0802:53Β  RichText
02:5403:43Β  Barcode
03:4404:22Β  Image

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info

Overview