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

Integrating Query Designer + Report Wizard

edited October 2002 in End User
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

Comments

  • edited October 2002
    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

This discussion has been closed.