Changing DBPiplines

rbuser

My aaplication uses 3 main tables which the user can design reports against.
My application has its own Query builder where the end user can create
Queries against these three tables. Can I take a query they build in my
Query builder and send it to the designer that is setup to design based on
the 3 tables?

nicocizik

Hi Rick,

The easiest way to do this would be to create new datamodules in DADE at run
time based on the queries that your users build. Then once the dataviews
are created in DADE, you're users will have full access to the data from the
Report Designer. Below is an example of creating a DADE dataview at
runtime.

http://www.digital-metaphors.com/tips/CreateDataModCustOrderLinkedDataViews.zip

--