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 |
|
bkana
Starting Member
18 Posts |
 Posted - 2006-12-22 : 15:44:31
|
| I run a report which displays transcripts for members. One page per person with their name, courses they've took, date of the course and their score. The problem I am having is when the report runs and comes across the same last name for many people (say, Hanna and Billy Alexander), it's only giving me the first "Alexander" it comes across and it is putting all the information for the other "Alexander's" in that first transcript. How do I separate out the people who's last name is the same say "Smith" or Jones"? I have a distinct clause on my query and when I run it I can see the other people with the same last name and their unique courses and scores (each of them have a unique member ID) - it's when I actually run the report that it groups the information (courses, dates, scores, etc) for the same last name people all under the first one it comes across. Hope that made sense.Thx,Billy |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-22 : 15:58:15
|
| You need to change the grouping in the report, either on the Groups tab of the Table Properties or on the Grouping and Sorting Properties of the group.Your grouping expression is currently only on LastName, it needs to be on LastName, then FirstName, or better still it should be by student ID. |
 |
|
|
bkana
Starting Member
18 Posts |
Posted - 2006-12-22 : 16:01:27
|
| Thank you snSQL. I'll try that and let you know what happens.Merry X-mass! |
|
|
|
bkana
Starting Member
18 Posts |
Posted - 2006-12-22 : 16:07:55
|
| I think that did it.....thank you so much!Again, have a wonderful holiday!Bkana |
|
|
|
|
|
|
|
|
Same last name causing problems in SQL RS