The TEssHtmlReport component descends from TDSTableProducer. See Delphi online help for properties and methods not covered here.

Published Properties

EmptyCellColor
FontFace
FontSize
GroupedFields
GroupedFieldsColor
Grouped
ReportSource
ShowNiceFields
SummaryFields

Public Properties and Methods

Content
HtmlText
ReportFunctions
PageText
SQL

Events

OnEvaluateFunction

 

 

Published Properties

EmptyCellColor Sets empty cells to this color. If blank, empty cells will have the fields title background color.
FontFace Font for the table. Must be a valid font name (i.e. Arial, Times New Roman, etc.)
FontSize Size of the font. Note, this is HTML size, not windows size. See HTML guidelines for help. Valid values are 1 to 7, -1 to -7, +1 to +7 and Default.
GroupedFields The fields you want grouped, separated by semicolons. The fields must be in the columns list either supplied into the component at design time or added via HTML scripting.
GroupedFieldsColor The color of the grouped field result cells. If blank, they will be the same color as the fields title background color
Grouped True if you want grouping applied, false if not.
ReportSource A file source containing any HTML file you want to use as the report template. Include any HTML scripting in the body of this file.
ShowNiceFields Changes all field letters to lower case except the first letter and replaces any "_" characters with a space.
SummaryFields

A list of the fields you want to use as summary fields. The notation is first the name of the field and then the desired function separated by a comma. Multiple summary fields are separated by a semicolon. Example: field1,function;field2,function;etc.

Possible functions include: addition (+), subtraction (-), multiplication (*), division (/), exponent (^), Sum, Avg, Max, Min, Count

 

Public Properties and Methods

Content Call this method to get the table inserted into the report. See Delphi online help for the TDatasetTableProducer component for more information.
HtmlText Returns the HTML text after a call to content. It strips out the carriage returns found in the PageText stringlist.
ReportFunctions

A sub class used to calculate the functions. There are two public methods exposed for this class:

Functions This is a string list of functions. It is filled with the default values of SUM, MAX, MIN, COUNT and AVG. You may add additional functions the list and perform your own function evaluation using the OnEvaluateFunction event. Only functions that have 1 or 2 arguments are allowed as added functions (i.e. Sin(x), Power(x, y), etc, but not Func(x, y, z)).
OnEvaluateFunction Event that is triggered by programmer added functions. All function evaluation is left to the programmer in this event. The values passed to the function are in reverse order (that is, a function with a single argument will pass that argument in Y, not as X). The function result should be passed back in the variable FuncResult.

 

PageText A TStringList of the HTML document loaded as the ReportSource. It is similar to HtmlText, but here it is as a stringlist rather than a single string.
SQL If a %sql=% script was added to the report source HTML document, it will be available here.