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

Erroneous results when joins are made on text fields which have data with "-" symbol

edited May 2006 in Datapipelines
Hi,
When trying to make a join between two tables based on a text field which
maybe having "-" character in it, the results are not as expected.
For example-

Datapipeline 1 Datapipeline 2
ABC-1 ABC-1
ABC1 ABC1

When joined on these fields, the report that comes up in the designer (using
subreport for datapipeline2 to show the linking) is:
ABC-1 (from datapipeline1)
ABC-1 (subreport data from datapipeline2)
ABC1 (subreport data from datapipeline2)
ABC1 (from datapipeline1)

This behaviour has been noticed only where "-" character is involved.

Can someone please enlighten me on this. Thanks in advance.

Regards,
Masha

Comments

  • edited May 2006

    Make sure that you do not have any event-handler code that manipulates the
    dataset in any manner while the report is generating.

    Are you using the ReportBuilder data workspace to link two queries? Or are
    you using external datasets that reside on a form/datamodule?

    We typically use the term 'join' to mean a SQL join between two tables that
    results in a single result set. I think what you are describing here is data
    linking between to queries.

    Please provide more details. Delphi version, RB version, Database, etc. Also
    provide details about how the data is configured and the report is
    configured.

    If possible, create a simple example that we can run here and email in zip
    format to support@digital-metaphors.com





    Best regards,

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