Integrating Query Designer + Report Wizard

rbuser

Hello again, hopefully for the last time. With your help, I have
successfully configured and called both the query wizard and report wizard
via code. Thank you!

Now, is it possible to integrate the two? I launch the query designer (via
code) and design my query. Now, when I launch the report wizard (via code),
how to I get it to recognize the query I designed with the query wizard
(i.e. the available pipelines and fields from the query)?

I notice going through the Report Designer, the Report Wizard recognizes the
query I design on the Data tab. It only lists the table and/or fields I
choose in the query designer. That is the funcionality I am looking for.
Thanks in advance.

Brian Kennedy
RB 6.03 (current project)
RB 7

digitalmetaphors

Yes, it should work. Forget about getting the report wizard to work
initially. The first thing to get working is to be able to run a report you
create on a form in which the data access comes from the dataview configured
by the runtime query designer. Are you this far? Once that is successful
then you should be able to run the report wizard after running the query
designer. The report wizard demo relies on the report's datapipeline to get
information during the wizard's events.

The query designer example configures a TdaSQL object. Let's take a step
back to see how to use this SQL object. The report has a datamodule object
which contains query dataview objects. Each query dataview object has a SQL
object. You need to create a query dataview in the report so that you can
assign the SQL object from the query designer. You can create a dataview in
code as shown in the example (link below). Then you can run the report
wizard based on the report's datapipeline which is assigned from the
dataview's datapipeline that you've just created.

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


Cheers,

Jim Bennett
Digital Metaphors