UNION
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
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
This discussion has been closed.
Comments
- 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