The Tips & Tricks pack contains several interesting solutions of common problems for
XL Report 4 developers. Each sample project resides in separate folder and requires
DBDEMOS in order to run. All of them were designed in Delphi 5.
\001 |
The use of a given Excel instance via the TxlReport.ConnectToExcelApplication class method.
|
\002 |
Forced freeing of Excel interfaces via the ReleaseExcelApplication class method (the xroOptimizeLauch option turned on).
|
\003 |
Creating and saving a report workbook with Excel hidden. Features:
- xroDisplayAlerts is off in order to suppress Excel warning if the target file already exists;
- xroAutoSave is on in order to permit to write the workbook;
- the ReportTo method.
|
\004 |
Creating a template at run-time in the TxlDataSource.OnBeforeDataTransfer event handler.
You can edit the query that is used as a data source for the Range01 range.
The range is defined in a template and consists of 4 cells.
|
\005 |
Numerating range rows via an Excel formula. The formula allows grouping in the range.
|
\006 |
XL Report run-time packages in main application and DLL. Be sure to include the DDEMan unit in the Uses clause of the dpr-file of the application.
|
\007 |
Several totals in a range. Pay attention to the formulas that "cover" the source range.
|
\008 |
The use of Excel interfaces outside of XL Report event handlers.
|
\009 |
Renaming worksheets of a target workbook when using the Report method.
|
\010 |
Adding a report to an open workbook and saving the resulting workbook under a new name.
|
\011 |
Demonstrates deleting macros from a report workbook.
|
\012 |
Demonstrates unbound data transfer (C++Builder).
|
xlReport
