| View previous topic :: View next topic |
| Author |
Message |
nolamiami
Joined: 01 Feb 2010
Posts: 1
|
 Posted: Thu Feb 04, 2010 4:08 pm Post subject: display unique/single records in report |
 |
|
I think there is a simple work around to this, but I can’t find it. I’m creating a report using multiple tables:
Name
Books
Magazines
When I run a query including just the Name and Books tables this is the result:
John
Book1
Book2
Book3
When I run a query including just the Name and Magazines tables this is the result:
John
Magazine1
Magazine2
Magazine3
But when I run the all three tables, I get:
John
Magazine1
Magazine1
Magazine1
Magazine2
Magazine2
Magazine2
Magazine3
Magazine3
Magazine3
Book1
Book1
Book1
Book2
Book2
Book2
Book3
Book3
Book3
Any help is appreciated. Hiding Duplicates doesn’t work, because the blank space of the duplicate record in the report makes the format unusable.
Visual Studio 2005
.NET Framework 2.0
SQL database backend |
|
| Back to top |
|
 |
venkat
Joined: 21 Aug 2007
Posts: 161
|
| Posted: Fri Feb 12, 2010 11:28 am Post subject: |
|
|
Hi nolamiami,
To help you in fixing the problem we need query you used.It is better if you can explain the relationship between three tables.
Venkat. |
|
| Back to top |
|
|
|
