Fundamentals |
The report |
Report designer |
Report options |
Report pages |
Managing pages |
Page properties |
Bands |
Bands in designer |
Configuring bands |
Printing Bands |
Band properties |
Report objects |
Common object properties |
The "Text" object |
Text editing |
Displaying the expressions |
Displaying the data columns |
HTML tags |
Object's properties |
The "Rich Text" object |
The "Picture" object |
The "Line" object |
The "Shape" object |
The "Barcode" object |
The "CheckBox" object |
The "Table" object |
The "Matrix" object |
The "Chart" object |
The "Zip Code" object |
The "Cellular Text" object |
Your first report in the FastReport |
Example 1. Creating a report manually |
Example 2. Creating a report with the wizard |
Report creation |
Choosing data for a report |
Dynamic layout |
CanGrow, CanShrink properties |
ShiftMode property |
GrowToBottom property |
Anchor property |
Dock property |
Formatting |
Border and fill |
Text formatting |
Styles |
Data formatting |
Conditional highlighting |
Hiding zero values |
Hide duplicate values |
Highlight odd/even data rows |
Report with one "Data" band |
Connecting a band to data source |
Printing the text |
Sorting the data |
Filtering the data |
Data header and footer |
Breaking data and keeping it together |
Printing empty data rows |
Printing "No data" text |
Printing hierarchy |
Master-detail report |
Master-master report |
Master-detail-detail report |
Multicolumn reports |
Page columns |
Data band columns |
"Booklet"-type reports |
Adding page into a report |
Page settings |
Printing on odd/even pages |
Groups and totals |
Creating groups |
Sorting the data |
Nested groups |
Managing groups |
Printing total values |
Repeating the header and footer |
Group properties |
Subreports |
Printing modes |
Side-by-side subreports |
Nested subreports |
Table-type reports |
Configuring columns |
Managing the size of the column |
Configuring rows |
Managing the size of the row |
Configuring cells |
Joining and splitting cells |
Inserting objects in cells |
Printing a table |
Printing complex headers |
Using totals |
Table layout |
Examples |
Example 1. Printing the whole table from top to bottom |
Example 2. Printing the table from top to bottom with a repeating row |
Example 3. Printing the whole table from left to right |
Example 4. Printing a table from left to right with a repeating column |
Example 5. Printing a table with repeating rows and columns |
Example 6. Using the data source |
Example 7. Inserting page breaks |
Example 8. Printing totals |
Matrix-type reports |
A few theory |
Configuring the matrix |
Configuring headers |
Configuring cells |
Styling the matrix |
Row and column size management |
Examples |
Example 1. Simple matrix |
Example 2. Multilevel headers |
Example 3. Printing the name of the month |
Example 4. Conditional highlighting |
Example 5. Highlighting even rows |
Example 6. Using Expressions |
Example 7. Pictures in cells |
Example 8. Objects in cells |
Example 9. Filling a matrix manually |
Interactive reports |
Hyperlink |
Hyperlink configuration |
Link to the URL |
Link to the page number |
Link to a bookmark |
Link to a detailed report |
Link to a detailed page |
Custom link |
Report outline |
Examples |
Example 1. Link to a web page |
Example 2. Building a detailed report |
Example 3. Interactive "Matrix" object |
Example 4. Report with table of contents, navigation and outline |
Report inheritance |
Creating a report |
Changing the base report |
Limitations |
Reports with charts |
Chart elements |
Chart editor |
Handling series |
Setting up the appearance |
Connecting chart to data |
Sorting the data |
Grouping the data |
Collecting the data |
Exploding the values |
Setting up auto-series |
Interactive charts |
Data |
The "Data" window |
Data sources |
Creating a data source |
Creating a SQL query |
Query parameters |
Passing a value to the parameter |
Editing a connection |
Editing a data source |
Aliases |
Hierarchical data sources |
Relations |
Creating a relation |
Editing a relation |
System variables |
Functions |
Mathematical |
Abs |
Acos |
Asin |
Atan |
Ceiling |
Cos |
Exp |
Floor |
Log |
Maximum |
Minimum |
Round |
Sin |
Sqrt |
Tan |
Truncate |
Text |
Asc |
Chr |
Insert |
Length |
LowerCase |
PadLeft |
PadRight |
Remove |
Replace |
Substring |
TitleCase |
Trim |
UpperCase |
Date & Time |
AddDays |
AddHours |
AddMinutes |
AddMonths |
AddSeconds |
AddYears |
DateDiff |
DateSerial |
Day |
DayOfWeek |
DayOfYear |
DaysInMonth |
Hour |
Minute |
Month |
MonthName |
Second |
Year |
Formatting |
Format |
FormatCurrency |
FormatDateTime |
FormatNumber |
FormatPercent |
Conversion |
ToBoolean |
ToByte |
ToChar |
ToDateTime |
ToDecimal |
ToDouble |
ToInt32 |
ToRoman |
ToSingle |
ToString |
ToWords |
ToWordsEnGb |
ToWordsRu |
Program Flow |
Choose |
IIf |
Switch |
Totals |
Creating a total |
Conditional totals |
Running totals |
Page totals |
Printing the total in the header |
Report parameters |
Creating a parameter |
Using parameters in a report |
Expressions |
Expression editor |
Reference to report objects |
Using .Net functions |
Reference to data elements |
Reference to data sources |
Reference to system variables |
Reference to total values |
Reference to report parameters |
Script |
General information |
Event handlers |
Report events |
Using .Net objects |
Reference to report objects |
Report and Engine objects |
Reference to data sources |
Rererence to system variables |
Reference to total values |
Reference to report parameters |
Examples |
Example 1. Changing object's appearance |
Example 2. Highlighting even rows of the band |
Example 3. Data filtering |
Example 4. Calculating total |
Example 5. Shifting the print position |
Dialogue forms |
Controls |
Referencing to a control from code |
Data filtering |
Automatic filtering - how it works |
Filter operations |
Adding filter into a report |
Filtering on data range |
Filtering on related data column |
Filtering using cascading lists |
Controlling the filtering from code |
Examples |
Example 1. "Hello, FastReport!" |
Example 2. Ask for a text from the user |
Example 3. Handling dialogue controls |
Example 4. Handling report objects |
Example 5. Simple filter |
Example 6. Automatic filtering |
Example 7. Automatic filtering by range |
Example 8. Filtering by related data column |
Preview, print, export |
Editing the report |
Printing the report |
Exporting the report |
Saving in FPX format |
Export to Adobe Acrobat (PDF) |
Export to Word (RTF) |
Export to HTML |
Export to MHT (web archive) |
Export to Excel (XML) |
Export to Excel 2007 |
Export to PowerPoint 2007 |
Export to OpenOffice Calc |
Export to CSV |
Export to TXT |
Export to picture |
Report design recommendations |
Sending the report by email |
© 2008-2010 Fast Reports Inc.