Obtaining Database Table Fields used in report

[StevenK]

I am writing an application in Delphi 5 and trying to retrieve a list of database fields that are actualy used in the report connected to. I can obtain the list of tables using the syntax :
tpTableName := CRReport.Database.Tables[tpI].Name;
I can then get a list of Fields for this table but this list contains the full set of fields regardless of whether used in the report or not.
Can anyone help point me in the right direction with this ?

 

[dcm]

StevenK: Can be doen BUT you'll have to navigate your way through the following:
1)Areas collection, which could contain multiple
2)Area Object, each one of which could contain multiple
3)Sections collection, which could contain multiple
4)Section Object, each one of which could contain multiple
5)Report Objects, each one of which could be a
6)Field Object which may have a DatabaseFieldDefinition.DatabaseFieldName property!

Have a look under DatabaseFieldDefinition Object CRE Object Model for the Automation Server

<Automation Server Object Model Index>

in the Developer Help David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[StevenK]

dcm : Have seen the idea you mention in the help files - however when I get down to the ReportObjects level I am without the 'Kind' property and cannot check if it is a database field - this may be specific to Delphi ?