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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- dall sheep hunting full curl identification guide
- hr strategy globalization human resource strategy
- introduction to javascript
- react native tutorialspoint
- ui technologies with full stack online
- thermo scientific crosslinking technical handbook
- beginner s essential javascript cheat sheet
- fastreport 4 user s manual
- javascript quick guide tutorialspoint
Related searches
- 4 p s of marketing definition
- 4 p s of marketing examples
- 4 p s of marketing mix
- 4 author s purpose for writing
- what are the 4 p s of marketing
- blackrock aladdin user s guide
- 4 a s of customer service
- marketing 4 p s ppt
- microsoft office 2010 user s guide
- change another user s password
- air force airman s manual pdf
- pa driver s manual 2018