changing non master table in report data model

Hi!

I'm already using the ReportOpenInfo variant of the open method to change the master table that is used on a report, as to permit the user to restrict on which records to run the report on (something like "print the address book of clients beginning with letter A").

I was wondering if there is a way to replace a table in the report's data model with another one, since there are times when it would be nice to filter the child table in a 1 to Many relation; for example, if I want to print the list of invoices with the associated payments, but I need to see payments status as if we were two months ago: I cannot put this filter on invoices, since this would exclude, for example, invoices that have no payment in the requested range, and I should instead pre-filter the list of payments that would be used as a child table.

dmRemoveTable/dmAddTable cannot be used for this purpose, as they make the UI object become disconnected from the fields; I would need something as dmReplaceTable (that doesn't exist!) which can replace a table in the dm with another WITHOUT losing association of the various fields...

Any ideas?Thanks!

Frelance IT consultant and programmer since 1991: www.atipica.it

No ideas? :)

Frelance IT consultant and programmer since 1991: www.atipica.it

I would probably make the child table the results of a query and run the query prior to opening the report.  That way you dont have to replace the table. 

Interesting problem though.  Since paradox can replace the table in a datamodel without loosing the field links, it should be possible to do this interactivaly.  Of course if the table structure is different field links would be lost.  For example, if the child table is not available when the report opens paradox gives you the opprotunity to find or replace the table in the datamodel.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com