Dynamic Table Names
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com