Creating New Report and Datapipelines dynamically.

rbuser

Is there an example or an explanation of how to create a new report, add a
datapipeline to the report, and then set the desired sql using the
SqlBuilder method.

I keep getting the error 'aDatapipeline is nil' when trying to create a new
report and set the sql using the SqlBuilder.

Actually when creating the SqlBuilder -

lSqlBuilder := TdaSqlBuilder.Create(ppReport.DataPipeline);

Is there an example that shows from start to finish.

Upon creating the new report, I then will open the query designer and then
the report wizard. Works certainly for the report explorer, but I am not
using the report explorer.

Do I need to add a Datapipeline to the report prior to the SqlBuilder
create?

Thanks.
Bill Brittain

nardmoseley

Here is an example.

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

When using DADE, the Report can have an associated TdaDataModule that is a
container for the QueryDataView object. Each QueryDataView has a DBPipeilne
and TdaSQL object. Looks like this...

TdaDataModule
DataViews[ ]:TdaQueryDataView
DataPipeline: TdaChildDBPipeline
SQL: TdaSQL




--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thanks Nard.

Had just found that example when you replied in a previous post.

Bill