Report Designer

Report Builder

• Report Builder - Overview
• Report Builder - Doing Simple Calculation
• Report Builder - Get Data Directly from DB
• Report Builder - Get Data from Available Pipeline

[top]

FAQ

How to rename the component I use?

01. Click Icon here (eg DBText)

02. Click on the place to be print/shown

03. At the Properties for XXXXXX, look for Identity | UserName & change the Name you like (Only Alphanumeric & no spacing)

[top]

Why when Export to PDF format the Company Logo look "ugly"?

01. In the report designer set the setting

- ImageCompressionLevel to 1

- Untick ScaleImages

02. At the Company Logo Right Click

- Tick DirectDraw

- Untick Stretch

03. Resize your Picture logo

- The Jpeg Logo

- Report builder Company Logo

[top]

Fast Report

• Fast Report - Overview
• Fast Report - Doing Simple Calculation
• Fast Report - Get Data Directly from DB
• Fast Report - Get Data from Available Pipeline
• Fast Report - Shift Relative To Simulator
• Fast Report - Down Then Across Column
• Fast Report - Continue Next Page & Continue From Previous Page
• Fast Report - E-Mail Client (Batch) & E-Mail (Native)
• Fast Report - SQL Lite Functions Commonly Use

----------------------------------------------------------------------------------------------------------------------------------------------------

When design for Fast Report Make sure the all the component in the MasterData or DetailData band set as following Height : 0.1 Stretch : True (Tick in Right Click)

----------------------------------------------------------------------------------------------------------------------------------------------------

[top]

FAQ

Why is not same on preview?

Try Untick the Option Shift by right click the Memo

[top]

Why my Layout in the Designer is different from the example shown?

Can try run This script. Please Exit SQL Product before run the script.

[top]

How to rename the component I use?

01. Click the Red A Icon.

02. Click on the place to be print/shown

03. At the Object Inspector, look for Name & change the Name you like (Only Alphanumeric & no spacing)

[top]

How to draw line for whole report?

01. Click at empty place of outer report.

02. At the Object Inspector, look for Frame & click the + sign

03. Under the Frame, look for Typ & set to True for ftLeft, ftRight, ftTop & ftBottom.

Make sure the Paper Margin for Top, Bottom, Left & Right not set to 0

[top]

How to add spacing between 2 records?

01. Right Click at DetailData.

02. Select Add child band.

03. At the Object Inspector, look for Height & set the gap Height you wanted

[top]

My More Description is very long & it shown page 1 empty & shown in page 2

01. Right Click at DetailData.

02. Select Allow Split.

03. Double Click OnAfterCalcHeight

04. Disable this script by add // infront

[top]

Show Note at Header

01. Right Click at GroupHeader:GroupHeader1.

02. Select Add Child Band & Select Stretch

03. Adjust the Child band Height as you wanted

04. Right click at Child Band & Select Stretch

05. Move all the Title to Child:Child1

06. Click Blue A icon (RichText Object)

07. Click on the place to be print/shown & set as below setting in Right Click

Stretch = True

Shift = False

Allow Expression = False

08. At the Object Inspector, Look for & set as below

DataSet ==> Main

DataField ==> Note

[top]

Show Total Qty Excluding Item Code RTN5Cents

01. Click the Red A Icon.

02. Click on the place to be print/shown

03. Enter the below code (make sure in the report had the AdjRound pipeline & GetTotal function (refer to Sales Invoice 7 (GST 1))

[FormatFloat(<Option."StockQuantityDisplayFormat">,
    IIF(Trim(<AdjRound."LocalAmount">)<>'0', 
          GetTotal('Qty')-1,
          GetTotal('Qty'))
)]

See also

• Report Designer at HIME
• Others Customisation