hello, i develop a VB .NET application using crystal report (Visual Studio 2008 OEM).
In my application, I have defined a dataset (an XSD file), and I have 3 DataTable in it. In application runtime, I filled up the 3 DataTable.
I made them independent each other so that there is no need to define links.
I want to display their records in one report, exactly one RPT file. In the Section 'Details' of RPT file, I put one field/column in each DataTable I have defined before. When I run the application, there are some duplicate records in the table whose less record. For example, table A has 2 records, table B & table C each has 1 record, then duplication happened on record in table B & C. It can says that, the number of the rows in the Section 'Details' always been forced to have number of rows in the most DataTable
Here is the illustration (assume I only fetch 1 column in each table):
table_A table_B table_C
------- ------- -------
recordA1 recordB1 recordC1
recordA2 recordB1 recordC1
then I try to have some experiment without usage of DataSet, I use 2 tables from MySQL database, and they are independent too. Table A has 2 records and table B has 3 records.
And then it displayed like this:
table_A table_B
------- -------
recordA1 recordB1
recordA1 recordB2
recordA1 recordB3
recordA2 recordB1
recordA2 recordB2
recordA2 recordB3
it looks like a cross-products between 2 tables
Actually I understand if they have a shared-field then I must define a key within the report displayed, but in the case they are independent each other.
How I fix this case?
thank you ...
Edited by danisupr4 - 10 Nov 2008 at 4:07am
IP Logged
