Skip to main content

Basic Guide

Understand on Toolbar​

  1. Report Object

    1

  2. Align Toolbar

    2

Sales Inovice Bands​

  1. Understand on Bands

    1. Group Header

      • Grouping Header
      • To Print on every page, right click on Group Header Band, select reprint on new page

    2. Master Data

      • The Main Dataset of the report
      • Normally Bind to Main Dataset
      • Each Page allows to have 1 Main Dataset Only

    3. Detail Data

      • To display all Item Details

    4. Group Footer

      • Grouping Footer
      • Display on Last Page only

    5. Page Footer

      • Display on Every Pages

  2. Sample Layout in Design Mode

    3

  3. Sample Layout on Preview Mode

    4

  4. Print Position

    • Group Footer content will be printed at the pixel value input.

    • Higher Value = Higher Footer

    • without setting with print position, the group footer will be printed after the document detail records.

    • Example Source Code:

      if Engine.FreeSpace < (GroupFooter1.Height + PageFooter1.Height + 30) then Engine.NewPage;

      Engine.CurY := Engine.PageHeight - GroupFooter1.Height - PageFooter1.Height - **60** ;
      note

      60 -> Higher Value = Higher Footer

    1. How to do the Print Position setting in Report?

      1. Click on Group Footer -> Click on Properties -> Events Tab -> Double Click on OnbeforePrint event name

        5

      2. Adjust the value

        6

  5. Stop Position vs Print Count

    Stop PositionPrint Count
    Details will stop at the input valueDetails will stop by number of records inputs
    RecommendNot recommend if using More Description
    Value in PixelNumber of Records

    1. How to do the Stop Position in Report?

      1. Right click DetailData1 -> Click on Events Tab -> Double click onAfterCalcHeight name

        7

      2. Setting the stop position

        8

        SMALL TIPS
        1. Set Either Print Count or Stop Position
        2. use // to disable the command
        3. When you set both Print Count and Stop Position, system will capture Print Count.

      3. Sample on Print Position / Stop Position

        9

How to design Simple Sales Invoice?​

  • Preview Invoice
  • Click on Report Name to enter to Design Mode

  1. Add PICTURE

    1. Click on Picture Object

      10

    2. Place on Report Page

      11

      • Fix Picture

        1. Click on Load

          12

        2. Select the Picture on your local drive

        3. Click on tick

          13

        4. Adjust to the desire size

          14

      • Capture Picture from Report Dataset

        15

  2. Text Memo

    Add Customer Email Address

    1. Click on Text Memo

      16

    2. Place on Report Page

    3. Enter Text : Email

      17

    4. Repeat Step i & ii

    5. Select Document_CompanyBranch -> Email Expression

      18

  3. Rich Text Object

    Add Note

    1. Click on RichText Object

      19

    2. Place on Report Page

    3. Select Main -> Note

      20

  4. System Text

    • Add Sum Qty

      1. Click on System Text Object

        21

      2. Place on the Report Page

      3. Select Aggregate value

        22

  5. Draw Line

    1. Click on Line

      23

    2. Place on the Report Page

    3. Draw a line

      24

  6. Center Horizontally in Band

    • Display the object in center horizontal

      1. Click on Object you want to show in center horizontal

      2. Click on Center Horizontally In Band

        25

  7. Align Left / Middle / Right

    1. Click on the multiple Object to Align as same alignment. System will follow the first object as alignment

      26

  8. Save the File

    1. File -> Save As -> Enter Report Name -> Save

    2. Preview and see the result

    Result:

    27

How to create the Subreport in Report?​

  • Preview Invoice

  • Click on Report Name to enter to Design Mode

    28

    1. Click on Subreport Object

      29

      1. Place on Report Page you want to show.

        30

    2. System will prompt a new blank page for Subreport

      31

    3. Click on Insert Band to design the layout or insert the data

      32

      **May refer 2.1 Understand Bands at Page 4 on what band to use

Check Box​

  1. Simple CheckBox

    1. Click on CheckBox object

      33

    2. Place on the place you want to show.

      34

    3. Press on the button

      35

    4. Select the frame design

      36

    5. Change to False

      37

    6. Save the File

      1. File -> Save As -> Enter Report Name -> Save
      2. Preview and see the result

    Result :

    38

  2. Query to show Check Box either True to False

    1. Click on CheckBox | Double Click OnBeforePrint

      39

    2. Place a Query below

      40

      Query:

      procedure Check/box1OnBeforePRint(Sender: TfrxComponent);
      begin
          if (Main."UDF_updated") = 'T' then
              checkbox1.checked := true
          else
              checkbox1.checked := false;
      end;

How to do Report Watermark?​

  1. Insert Band | Select Overlay

    41

  2. Insert Picture / Text to load in the water mark

    42

  3. Overlay size can drag the same size as A4/Letter, and place the watermark on the position you want to show.

    43

  4. File | Save As: Enter report name

  5. Preview and see the Result :

    44

Frequently Ask Question (FAQ)​

1. Unit price is 0, display as FOC​

In Memo, enter following syntax :

[FormatFloat(',0.00;-,0.00;FOC ',<Document_Detail."UnitPrice">)]

45

2. Document Currency Description change Cents to Sens​

Syntax:

[Document_Currency."Description"] : [StringReplace(CurrencyToLangWord(<Main."DocAmt">,<Profile."CurrencyLang">), 'CENTS', 'SENS', TRUE)]

46

3. More Description convert RichTextToPlainText​

Syntax :

[RichTextToPlaintext(<Document_Detail."Description3">)]

47

48

4. How to change report paper size?​

File -> Page Setting ->

49

5. if Qty > 10, text color in red and in bold?​

  1. Double Click on Memo

  2. Click on Highlight Tab

  3. Click on Add Button

  4. Expression value > 10

    50

  5. Click on Font

    Can set for Font Type, Font Style, Size, Color or Effects

    51

  6. Press OK

  7. Right Click on Memo, Ticked Allow Expression

Result :

52

6. Why in Report I have placed at the position I want, but when preview it will show at bottom?​

Right click on Memo, unticked Shift and Unticked Shift when Overlapped

7. Export to PDF Logo is blur​

53

8. How to capture remark1 as url path?​

In Memo properties :

Hyperlink Expression added in the Data Field Name

54

Result :

55

9. Payslip to show AL or MC Only​

  1. Click on SubReport3

  2. Right click on Leave MasterData Band 56

  3. Click on Filter button

  4. Enter the expression :

    (<Leave."LeaveType"> ='AL') OR (<Leave."LeaveType"> ='MC')

  5. Press OK

  6. Press OK

    57

10. How to get Net Unit Price​

  1. Click on Memo Text

  2. Place on Document Detail Band

  3. Drag data field from right to left box :

    [<Document_Detail."Amount"> / <Document_Detail."Qty">]

  4. Press OK

  5. Adjust the position

  6. Preview and see the result

58

11. UOM = UNIT, Qty display without Decimal Point, else with 2 Decimal Point​

  1. Click On Memo Text

  2. Copy the below syntax and Paste into Memo:

    [IIF(<Document_Detail."UOM"> = 'UNIT'>,
    FormatFloat('#,0;-#,0 ', <Document_Detail."Qty">) ,
    FormatFloat('#,0.00;-#,0.00 ', <Document_Detail."Qty">))]

    59

  3. Press OK

  4. Result After Preview :

    60

12. How to Get Supplier Bank in Payment Voucher?​

  1. Click on Memo A

  2. Paste this syntax inside Memo

    [<GetbankName(pl_SUPPLIERBANKACC."Bank">)]

    61

13. How to change the Amount in Word to First Character to Upper Case only?​

Can use function NameCase

62

Before :

63

After :

64