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
