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

UNION

edited December 2006 in End User
Is there any way that I can use the Data tab on the report builder IDE, if
i'm doing a UNION in my query. I need to be able to link the result of the
UNION query to other tables. I know everything becomes disable when the
SQL is edited. Any work around?



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • edited December 2006

    - The DataPipeline.AddLink method can be used to programmatically add a
    link. Here is an example.

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

    - for the datapipeline linking to work correctly, the detail data needs to
    be ordered by the linking field (in other words, add an 'order by' to the
    detail SQL)


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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.