Erroneous results when joins are made on text fields which have data with "-" symbol
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
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
This discussion has been closed.
Comments
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