Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Dynamic Tables

edited October 2004 in End User
Hello,

I have Tables which has same fields like 'Table_1','Table_2','Table_3'...
For example, end user, design a report on 'Table_1', when he save the
report, i have to save to RBItem's Template Field or rtm file as Table_x.
Because he can use the same design for 'Table_2' or 'Table_3', not just for
'Table_1'. How can I achieve this ?

Regards,
N.Tunur

Comments

  • edited October 2004

    I think the approach would be to modify the dataview when the report loads,
    rather than trying to modify what is saved down.

    There are two options:

    1. You can write code to extract the TdaSQL object from the DataView and
    modify it.

    www.digital-metaphors.com/tips/ExtractSQLObject.zip

    2. Create your own custom dataviews. We only examples for the BDE, but they
    can be copied to support ADO. Some of the code you will need to copy is
    located in daDBBDE.pas - it contains the ancestor classes to the classes
    that are created by the dataviews.



    --


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.