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

Dynamic Table Names

edited November 2005 in End User
Hi all

I have a sql database where a company code is included as part of the
table name eg PA_DEM_AAA and PA_PKP_AAA has the same table structure,
but for 2 different companies DEM and PKP.

How would an end user create a report so that it would look at the
correct table no matter what the company code is (ie make the 3 middle
letters some type of variable, so in the report designer you could have
PA_???_AAA and the ??? gets filled in)?

At present the only way I can think to do this is to create a seperate
report for each company code. I need a solution where not code is
written in the application that runs the reports.

Cheers
Carl

Comments

  • edited November 2005
    Hi Carl,

    Are you using a registered version of ReportBuilder or an application with
    ReportBuilder built in? I'm a bit confused about what exactly you would
    like to happen. Datasets can dynamically be created in Delphi or in DADE.
    If you are using the latest version of ReportBuilder, you may be able to use
    one of the new RAP events such as BeforeOpenDataPipelines to create a
    dataview based on some user input.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.