Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vsankarv
Starting Member
2 Posts |
 Posted - 2007-05-08 : 23:41:44
|
| I have a report that is built using the report builder and the report model that was created. With the fields that are displayed in the report, it could be possible for the database to have multiple rows with the same values for all the fields (that are displayed in the report). The PK will be different, but this is not displayed in the report as the PK won't make sense in the report. So what happens is that the report displays just 1 record even though the database has multiple records because all the fields (that are displayed in the report) are identical. Is there a way to make the report display all the rows irrespective of duplicates? |
|
|
monktrain
Starting Member
4 Posts |
Posted - 2007-05-09 : 15:32:03
|
| It sounds like the problem may be with your SELECT statent. I could be that you have the wrong kind of JOIN clause in your statement. I would start there.D-Monk |
 |
|
|
|
|
|
Display all rows (including duplicates) in report