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.