Report Builder - Get Data Directly from DB

Introduction

Sometime in the report you might wanted some extra information but you not able to select in the report design. So we had to self query to get the extra information.

Steps

Below is example using Sales Invoice to get Shelf field from Maintain Item

01.

02.

03.

04.

05.

06.

07. Enter the below script

procedure Variable2OnCalc(var value: Variant);
var s: string;
begin
  s := 'SELECT Shelf FROM ST_ITEM ' +
        'WHERE CODE=' + QuotedStr(Document_Detail.GetFieldValue('ItemCode'));
  if Trim(DBSQL_GetFieldValue(s)) <> '' then
    Value := Trim(DBSQL_GetFieldValue(s));
end;

• More coming soon...