Microsoft Excel reporting and 
 data analyzing with practically no coding. 
 .Net, ActiveX, and VCL versions. 
 www.AfalinaSoft.com  

Home    Products    Downloads    Registered users    Support    Prices    Order    Primary Subscription

 

MS Office COM Add-ins. Microsoft Excel reporting 
 and data analyzing


TxlDataSource class - AfalinaSoft XL Report Programmer's Reference

<< Previous

Table of contents

Next >>


TxlDataSource class

Unit: xlReport

This class represents an item of the collection (a TCollectionItem descendant) used to bind a dataset to a report (i.e. with the instance of TxlReport). Its main purpose is to describe a data set supplying data for a report. Create instances of this class using methods of the DataSources collection or the TxlReport.AddDataSet method. Fill the properties needed while editing the form or at run-time. Here are the properties:

  • DataSet - a dataset, an instance or a descendant of the TDataSet class;
  • Range - the name of the range whose cells should be filled with the dataset data;
  • Options - range options;
  • MacroAfter / MacroBefore - macro's names that will be executed after/before data transfer.

Example:

Report.DataSources[0].MacroBefore := '';
Report.DataSources[0].Range := 'CustRange';
Report.DataSources[0].MacroAfter := 'Module1.BuildPivotTable';
Report.DataSources[0].DataSet := qryCustomers;

Because this class is not designed to be used alone, it doesn't contain published methods. In addition to properties, the TxlDataSource class contains several events that can be useful in some reports.












<< Previous

Table of contents

Next >>



Components

xlReport xlReport

Developed for

Delphi 4, 5, 6, 7
C++Builder 4, 5, 6

Excel version supported

MS Excel 97 (SR2)
MS Excel 2000
MS Excel 2002 (XP)
MS Excel 2003



[ Download it ]
[ Order now ]



We are Borland 
 technology partner

Copyright © 1999-2006
All right reserved.
Privacy Policy

Write to WebMaster

Page Top
Add-in Express - Visual tool for Office customization