FlexCel.Report Namespace

This is the FlexCel reporting engine. You need to use this unit when using the class TFlexCelReport.

Classes

Name	Description
TCustomizeChart​Event​Args	Arguments passed on TFlexCelReport.​Customize​Chart
TFlexCelReport	Component for creating reports on Excel based on a template. It will read an xls file, replace tags with data read from a database or memory, and save a new file with the data.
TFlexCelReport​Progress	Indicates how much of the report has been generated.
TFlexCelUserFormat	A class used to define a cell format in code, that you can call from a report.
TFlexCelUserFunction	A class used to define a FlexCel user function, that you can call from a report.
TGenerateEventArgs	Arguments passed on TFlexCelReport.​Before​Generate​Workbook, TFlexCelReport.​After​Generate​Workbook, TFlexCelReport.​Before​Generate​Sheet and TFlexCelReport.​After​Generate​Sheet
TGetImageData​Event​Args	Arguments passed on TFlexCelReport.​Get​Image​Data
TGetIncludeEventArgs	Arguments passed on TFlexCelReport.​Get​Include
TLoadTableEventArgs	Arguments passed on TFlexCelReport.​Load​Table
TOneCellValue	A list of TOneSectionValue. Has a parsed version of what is on a cell.
TRelation	A data relation between two tables. Different from standard .NET datarelations, this class is not tied to ADO.NET, and allows you to specify relationships between any arbitrary VirtualDataTable objects.
TSplitLink	Specifies a "Split" relation between two tables.
TUserTableEventArgs	Arguments passed on TFlexCelReport.​User​Table
TVirtualDataTable	Base class for a table used on FlexCelReport. Inherit from this class and TVirtualData​Table​State to create your custom sources of data. Make sure you read 'Appendix virtual datasets' in the Reports Developer Guide for more information.
TVirtualData​Table​State	A table that corresponds to a band on the report. Make sure you read 'Appendix virtual datasets' in the Reports Developer Guide for more information.

Records

Name	Description
TFlexCelData​Conversion​Args	Contains the arguments for a TFlexCelData​Conversion​Event.​
TLookupField​Definition	Encapsulates the data for a lookup tag in a report.
TMasterDetailLink	A parent table and a parent field used on a master-detail relationship.
TReportTag	Tags used in reports.
TReportValue	Contains the values you can enter inside a report. This might be a TCellValue, an array of CellValues or an image as a ByteArray.

Enumerations

Name	Description
TAggregateType	Enumeration with the different kind of aggregations that can be done in a FlexCelReport.
TApplyFormatTagEnum	Configuration strings used in applying a part of a format. Internal use.
TConfigTagEnum	Configuration strings. Internal use.
TDeleteEmptyBands	Defines how bands will be removed when they have 0 records.
TDisposeMode	Indicates if FlexCel must dispose a table after it is done using it.
TErrorActions	Enumerates what to do on different FlexCel error situations.
TFlexCelReport​Progress​Phase	Phase of the report we are in.
TRecordCountMode	Sets the way FlexCel will count the records.
TSqlParametersType	How the parameters for Direct SQL queries are. Change it only if your database uses positional parameters and it is not ODBC or OLEDB.
TValueType	All the things we can find on a cell.

Anonymous methods

Name	Description
TFlexCelData​Conversion​Event	A function to convert a class, record or array into a value FlexCel can write in the template. "v": Value to be converted. "ConvertedValue": In this variable you need to return the converted value.
TFlexCelSQLParameter​Method	Use this method to assign the SQL parameters in a query.​ ​"param​Name"​: This is the parameter we are setting. This name doesn't include the ":" or "@" prefix for the parameter\.<br /><br /><br />"dataset": This is the dataset where you need to assign the parameter. You will need to cast this value to the specific TDataSet you created in TFlexCelSQLQuery​Method, and assign the parameter there.
TFlexCelSQLQuery​Method	Use this method to return a dataset where FlexCel can execute the SQL Query. The type of dataset you return depends on the database you are accessing and the Delphi components you are using to access that database.

Types

Name	Description
TCustomizeChart​Event​Handler	Delegate for CustomizeChart event.
TGenerateEvent​Handler	Generic delegate for After/Before generate events.
TGetImageData​Event​Handler	Delegate for GetImageData event.
TGetIncludeEvent​Handler	Delegate for GetInclude event.
TLoadTableEvent​Handler	Delegate for LoadTable event.
TUserTableEvent​Handler	Delegate for UserTable event.