By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,268 Members | 1,371 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,268 IT Pros & Developers. It's quick & easy.

Duplicated records in a report from two tables

P: n/a
I'm trying to create a report in a dotnet.asp project. I made the report in
Crystal Reports based on a dataset with two tables linked in a one to many
relationship. The output report shows me duplicated records. For example, if
one person has two medical visits I see four visits, two of these are
completely duplicated.
I don't understand why because the relation between the two tables has been
defined.
Has someone had the same problem?
Many thanks!
--
Isabel
Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sorry,
I have resolved the problem, not with the code but creating my query with
the two tables in the origine, that is in the database (MSQLS). Then I have
created a Dataset with that query as it was a table. My report is based on
this table in the dataset and the rest is easy. The important thing is that
it works without having duplicate records in the report.
Thank you however,
Bye,
Isabel

"Isabel Puigdevall" wrote:
I'm trying to create a report in a dotnet.asp project. I made the report in
Crystal Reports based on a dataset with two tables linked in a one to many
relationship. The output report shows me duplicated records. For example, if
one person has two medical visits I see four visits, two of these are
completely duplicated.
I don't understand why because the relation between the two tables has been
defined.
Has someone had the same problem?
Many thanks!
--
Isabel

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.