FastReport 4 User's Manual

[Pages:217]FastReport 4 User's Manual

? 1998-2012 FastReports Inc. Manual Version 1.2.0

I

FastReport 4 User's Manual

Table of contents

Chapter I Designer

2

1 Control ke.y..s................................................................................................................................ 3 2 Mouse con..t.r..o..l............................................................................................................................ 3 3 Toolbars ................................................................................................................................... 4

Designer m..o..d..e...b..a..r............................................................................................................................................ 4 Standard to..o..l.b...a..r............................................................................................................................................... 4 Text toolba.r........................................................................................................................................................ 5 Frame tool.b..a..r.................................................................................................................................................... 6 Align toolb.a..r...................................................................................................................................................... 7

4 Designer o..p..t.i.o...n..s........................................................................................................................ 8 5 Report set.t.i.n...g..s........................................................................................................................... 9 6 Page opt.i.o..n..s............................................................................................................................. 13

Chapter II Creating reports

16

1 Report ob..j.e..c..t..s.......................................................................................................................... 16 2 "Hello, W.o...r.l.d..!."...r..e..p..o..r.t...e..x..a..m...p..l.e............................................................................................... 16 3 The "Tex.t."...o..b..j.e..c..t..................................................................................................................... 17 4 HTML-tag..s...i.n...t..h..e...".T...e..x..t."...o..b..j.e..c..t.............................................................................................. 19 5 Displayin.g...e..x..p...r.e..s..s..i.o..n...s...w..i.t..h...t.h..e...h..e..l.p....o..f..t.h...e...".T...e..x..t."..o...b..j.e..c..t................................................. 20 6 Bands in..F..a..s..t.R...e..p..o..r.t................................................................................................................ 21 7 Data ban.d..s................................................................................................................................ 23 8 TfrxDBDa..t.a..S...e..t..c..o..m...p..o...n..e..n..t..................................................................................................... 23 9 "Custom.e..r..L..i.s..t."...r..e..p..o..r.t............................................................................................................ 24 10 Displayin.g...D...B....f.i.e..l.d..s...w...i.t.h...t..h..e...h..e..l.p...o...f..t.h..e..."..T..e..x..t."...o..b..j.e..c..t....................................................... 26 11 Aliases ................................................................................................................................... 27 12 Variables................................................................................................................................... 28 13 "Picture"..o..b...j.e..c..t....................................................................................................................... 30 14 Report w.i.t.h...p..i.c..t..u..r.e..s................................................................................................................. 31 15 Multi-line.d...t..e..x..t..d..i.s..p..l.a..y............................................................................................................. 33 16 Data split..t.i.n..g............................................................................................................................. 35 17 Text wrap...o..f...o..b..j.e..c..t.s................................................................................................................. 37 18 Displayin.g...d...a..t.a...i.n...t.h...e...f.o..r.m.....o..f..a...t.a..b..l.e..................................................................................... 39 19 Printing l.a..b..e..l.s........................................................................................................................... 41 20 Child-ban..d..s............................................................................................................................... 43 21 Shifting o..b..j.e..c..t.s......................................................................................................................... 44 22 Report w.i.t.h...t.w...o....d..a..t.a...l.e..v..e..l.s...(.m...a..s..t..e..r.-.d..e..t..a..i.l.).......................................................................... 45

? 1998-2012 FastReports Inc.

Table of contents

II

23 Headers a..n...d...f.o..o...t.e..r.s...o..f...a...d..a..t.a...b..a..n..d........................................................................................ 48 24 Multi-pag.e...r..e..p..o..r..t.s.................................................................................................................... 50 25 RowCoun..t..a..n...d...P..a..g..e..C...o..u...n..t..p..r..o..p..e..r.t..i.e..s................................................................................... 51

Chapter III Groups and aggregates

53

1 Report w.i.t.h...g..r..o..u..p..s................................................................................................................... 53 2 Other gro..u..p...f.e..a..t..u..r.e..s................................................................................................................ 55 3 Reset pag...e...n..u..m...b..e..r..s................................................................................................................ 57 4 Drill-dow.n...g..r..o..u..p..s..................................................................................................................... 57 5 Line num.b...e..r.i.n..g......................................................................................................................... 58 6 Aggregat.e...f.u..n...c..t.i.o..n..s................................................................................................................. 59 7 Page and..r..e..p..o..r..t..t.o..t.a..l.s.............................................................................................................. 61 8 Inserting..a..g..g..r.e..g...a..t.e...f.u..n..c..t..i.o..n..s................................................................................................. 62

Chapter IV Formatting, highlighting

65

1 Formattin..g...o..f...v..a..l.u..e..s................................................................................................................ 65 2 Inline for.m...a..t.t.i.n..g........................................................................................................................ 66 3 Condition..a..l..h..i.g...h..l.i.g..h..t.i.n...g.......................................................................................................... 67 4 Coloring .a..l.t.e..r..n..a..t.e...d..a..t..a...r.o..w...s................................................................................................... 68

Chapter V Nested reports (subreports)

71

1 Nested re..p..o..r..t.s...(.s..u..b..r..e..p..o..r..t.s..)................................................................................................... 71 2 Side-by-s.i.d...e...s..u..b..r..e..p..o..r.t..s.......................................................................................................... 71 3 Limitation...s...o..n...u..s..e...o..f...s..u..b..r.e..p...o..r.t..s........................................................................................... 72 4 PrintOnP.a..r.e..n...t..o..p..t.i.o...n............................................................................................................... 73

Chapter VI Script

75

1 A Taste o.f...S..c..r.i.p...t...................................................................................................................... 76 2 Structure..o...f..a...s..c..r.i.p..t................................................................................................................. 78 3 "Hello, W.o..r..l.d..!."...s..c..r.i.p..t............................................................................................................... 80 4 Using ob.j.e..c..t.s...i.n...t.h...e...s..c..r.i.p..t...................................................................................................... 80 5 Calling th..e...v..a..r.i.a..b..l.e..s...f..r.o..m....t..h..e...r.e..p..o...r.t.'.s...v..a..r..i.a..b..l.e..s...l.i.s..t........................................................... 81 6 Referenc.i.n..g...t.h...e...D..B....f.i.e..l.d..s........................................................................................................ 82 7 Using ag.g..r.e..g..a..t..e...f.u..n..c..t.i.o...n..s...i.n...t.h...e...s..c..r.i.p..t................................................................................ 83 8 Displayin.g...a...v...a..r.i.a..b..l.e..'.s...v..a..l.u..e...i.n....a...r.e..p..o..r..t............................................................................... 83 9 Events ................................................................................................................................... 83 10 Example .o..f...u..s..i.n..g...t.h...e...".O...n..B...e..f.o...r.e..P..r..i.n..t."...e..v..e..n..t....................................................................... 85 11 Printing a...g..r..o..u..p...s..u..m.....i.n...t.h..e...g..r..o..u..p....h..e..a..d..e..r............................................................................ 87 12 "OnAfterD...a..t.a.."...e..v..e..n..t................................................................................................................ 91 13 Service o.b...j.e..c..t.s......................................................................................................................... 92

"Report" .o..b..j.e..c..t............................................................................................................................................... 92

? 1998-2012 FastReports Inc.

III

FastReport 4 User's Manual

"Engine" .o..b..j.e..c..t............................................................................................................................................... 93 "Outline".o...b..j.e..c..t.............................................................................................................................................. 94

14 Using the..."..E..n..g..i.n...e.."..o...b..j.e..c..t...................................................................................................... 95 15 Anchors ................................................................................................................................... 97 16 Using the..."..O..u...t.l.i.n..e.."...o..b..j.e..c..t...................................................................................................... 99 17 "OnMan.u...a..l.B..u..i.l.d..."...p..a..g..e...e..v..e..n..t............................................................................................... 102 18 Creation...o..f..o...b..j.e..c..t.s...i.n...t.h...e...s..c..r.i.p..t........................................................................................... 107

Chapter VII Cross-tab reports

109

1 Constru.c..t.i.n...g...a...c..r.o..s..s..-..t.a..b...r.e..p...o..r.t........................................................................................... 110 2 Changin..g...t.h..e...a..p...p..e..a..r.a..n..c..e...................................................................................................... 112 3 Using fu..n..c..t.i.o..n...s...................................................................................................................... 114 4 Sorting .v..a..l.u..e..s......................................................................................................................... 115 5 Tables w...i.t.h...c..o..m...p...o..s..i.t.e...h..e..a..d...e..r.s............................................................................................ 115 6 Adjustin..g...c..e..l.l..w...i.d..t.h................................................................................................................ 117 7 Font col.o...r.s...a..n..d...h...i.g..h..l.i.g..h..t..i.n..g................................................................................................. 119 8 Managin..g...a...c..r..o..s..s..-.t.a..b...i.n....s..c..r.i.p..t............................................................................................. 121 9 Adjustin..g...r.o..w.../.c..o...l.u..m...n...s..i.z..e.................................................................................................... 125 10 Filling a..t.a..b..l.e...m....a..n..u..a..l.l.y.......................................................................................................... 126 11 Adding .e..x..t.e..r.n..a..l..o...b..j.e..c..t.s...t.o....t.h..e...t.a..b..l.e..................................................................................... 128 12 Some us..e..f..u..l..s..e..t.t.i.n..g...s............................................................................................................. 130

Chapter VIII Charts

134

1 Limiting..t..h..e...n..u..m...b...e..r..o..f..c..h...a..r.t..v..a..l.u...e..s.................................................................................... 138 2 Some us..e..f..u..l..s..e..t.t.i.n..g...s............................................................................................................. 139 3 Chart w.i.t.h...m...a..n..u...a..l.l.y...e..n..t.e..r.e..d....v..a..l.u..e..s..................................................................................... 139 4 Chart co..m...p..l.e..t..i.o..n...f.r..o..m....S..c..r..i.p..t............................................................................................... 140 5 Printing..a...c..h..a..r..t..b..u..i.l.t..i.n....D..e..l.p..h...i............................................................................................. 141

Chapter IX Dot-Matrix reports

143

1 Cross-ta..b...i.n...d...o..t.-.m...a..t..r.i.x.......................................................................................................... 146 2 Dot-mat.r.i.x...r..e..p..o..r..t..p..r.i.n...t.i.n..g...................................................................................................... 147 3 "Comma..n...d.."...o..b..j.e..c..t................................................................................................................ 148

Chapter X Dialogue forms

151

1 Controls................................................................................................................................... 151 2 "Hello, W...o..r..l.d..!."...r.e..p..o...r.t............................................................................................................ 152 3 Entering...p..a..r..a..m...e..t.e..r.s...a..n...d...t.r.a..n...s..f.e..r.r..i.n..g...t.h..e..m.....i.n..t.o...a...r..e..p..o..r..t................................................. 154 4 Interacti.o...n...w...i.t.h...c..o..n..t..r.o..l.s........................................................................................................ 154 5 Several .d..i.a..l.o...g..u..e...f.o..r..m...s.......................................................................................................... 155 6 Managin..g...d..i.a..l.o...g..u..e...f.o...r.m...s...................................................................................................... 156

? 1998-2012 FastReports Inc.

Table of contents

IV

Chapter XI Data access components

159

1 Compon..e..n..t..d...e..s..c..r.i.p..t.i.o...n..s....................................................................................................... 160

TfrxDBLo...o..k..u..p..C...o..m...b..o..B...o..x............................................................................................................................. 160 TfrxADO.T..a..b..l.e................................................................................................................................................. 161 TfrxADO.Q...u..e..r.y................................................................................................................................................ 163 TfrxADO.D..a..t.a..B...a..s..e.......................................................................................................................................... 165

2 Report d..e..s..i.g..n...e..r..................................................................................................................... 165 3 Simple r.e..p...o..r.t...o..f.."..L..i.s..t."...t.y..p..e................................................................................................... 166 4 Report w...i.t.h...p..a..r..a..m...e..t.r..i.c...q..u..e..r.y................................................................................................ 167 5 Other us..e..f.u...l..f.e..a..t.u..r..e..s............................................................................................................. 169

Chapter XII Report inheritance

171

1 Creating...a...b..a..s..e...r..e..p..o..r.t........................................................................................................... 171 2 Changin..g...a...b..a..s..e...r..e..p..o..r.t......................................................................................................... 173 3 Inheritan...c..e...c..o..n..t.r..o..l................................................................................................................ 174

Chapter XIII Wizards

177

1 New rep.o...r.t..w...i.z..a..r.d................................................................................................................... 177

2 New con..n..e..c..t..i.o..n...w...i.z..a..r.d.......................................................................................................... 181

3 New tab.l.e...w...i.z..a..r.d..................................................................................................................... 182

4 New que..r..y...w..i.z..a..r..d................................................................................................................... 183

5 Query c.o..n..s..t.r..u..c..t.i.o..n................................................................................................................. 183

Using th.e...Q..u...e..r.y...c..o..n..s..t.r.u...c..t.o..r........................................................................................................................ 186 Complex...q..u..e..r.y...b..u..i.l.d..i.n...g................................................................................................................................ 188

Chapter XIV Report viewing, printing and export

192

1 Control .k..e..y..s............................................................................................................................ 193

2 Mouse c..o..n..t.r..o..l........................................................................................................................ 194

3 Report p..r..i.n..t.i.n..g........................................................................................................................ 194

4 Text sea..r.c..h...i.n....r.e..p..o..r..t.s............................................................................................................ 196

5 Report E..x..p...o..r.t......................................................................................................................... 197

Export to...P..D...F...F..o..r..m...a..t................................................................................................................................... 198 Export to...O...p..e..n...D...o..c..u..m...e..n..t............................................................................................................................ 199 Export to...R...T..F...F..o..r..m...a..t................................................................................................................................... 199 Export to...E..x..c..e..l.............................................................................................................................................. 200 Export to...X..M...L....F..o..r.m...a..t................................................................................................................................... 201 Export to...C...S..V...F...o..r.m...a..t................................................................................................................................... 202 Export in..t.o...H...T..M...L...F..o..r..m...a..t............................................................................................................................. 203 Export to...T..e..x..t..F..o...r.m...a..t................................................................................................................................... 204 Export to...J..p..e..g..,..B...M...P..,..G...i.f.,..T..i.f.f...G..r..a..p..h..i.c...F..o..r..m...a..t.s.......................................................................................... 205

6 Sending...a...R..e..p..o...r.t..v..i.a...E...-.m...a..i.l................................................................................................. 206

7 Report D...e..s..i.g..n...c..o..n..s..i.d...e..r.a..t.i.o..n...s.............................................................................................. 208

? 1998-2012 FastReports Inc.

Chapter

I

Designer

Designer 2

The report component is supplied with an embedded visual report designer, which can be opened at design-time by double-clicking on the TfrxReport component. The designer provides the user with all the tools necessary for designing and previewing reports. The designer's interface meets current requirements. It contains several toolbars, which can be docked wherever wanted. These toolbar locations are restored every time the designer is opened. Toolbar locations, together with other designer settings, are stored in the registry or, should one be assigned, in an ini-file.

To give the end user of your project the ability to design reports, you should either place a "TfrxDesigner" component from the FastReport component palette onto a Delphi form or add the "frxDesgn" unit to the unit's Uses list (NB: spelling). Using the designer at run-time allows the user to change the report's appearance, as well as to edit the finished report. Note: you should also place any other Tfrx components that will be used on the Delphi form.

Key to report designer features: 1 report design workspace 2 menu bar 3 toolbars 4 object toolbar 5 report page tabs 6 "Report tree" pane

FastReport v4 ? 1998-2012 FastReports Inc.

Manual v1.2.0

3

FastReport 4 User's Manual

7 "Object inspector" pane 8 "Data tree" pane : elements can be dragged from this pane onto a report page 9 rulers : a ruler can be dragged onto a report page to create a blue guideline on the page

(objects snap to nearby guidelines) 10 status bar

1.1 Control keys

Keys Ctrl+O Ctrl+S Ctrl+P Ctrl+Z Ctrl+C Ctrl+V Ctrl+X Ctrl+A Arrow, Tab

Del Enter Shift+arrows Ctrl+arrows Alt+arrows

Description "File > Open..." menu command "File > Save" menu command "File > Preview" menu command "Edit > Undo" menu command "Edit > Copy" menu command "Edit > Paste" menu command "Edit > Cut" menu command "Edit > Select all" menu command move between objects delete selected object(s) open editor for selected object modify sizes of selected object(s) move selected object(s) attach selected object to adjacent object in specified direction

1.2 Mouse control

Operation Left button

Right button Double-click

Mouse wheel Shift + left button Ctrl + left button

Description

select object; paste new object; move or resize objects for selected objects, zoom in and out by dragging red square

in bottom left corner of selected objects' group

selected object's contextual menu

open editor for object double-clicking on white space opens the "Page Settings"

dialogue

scroll report page

toggle object selection

create frame by moving mouse

FastReport v4 ? 1998-2012 FastReports Inc.

Manual v1.2.0

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download