August 7, 2008 at 6:04 am
Hello,
I am new to sql server and reporting services. I have created a report which shows duplicate rows even though the dataset has not duplicates.
As an example, the dataset (created via a procedure) returns 6 students.
student a
student b
student c
student d
student e
student f
But the report, only returns the first row 6 times.
student a
student a
student a
student a
student a
student a
Can anyone help me? I have no idea what I have done to cause this problem.:crying:
Thank you,
Jacqueline Marquardt
programmer/analyst
August 7, 2008 at 10:02 am
Sounds like you've ended up with the FIRST aggregate attached to your field.
Change FIRST(Fields!student.Value) to just Fields!student.Value.
That should do it.
HTH
[font="Comic Sans MS"]toolman[/font]
[font="Arial Narrow"]Numbers 6:24-26[/font]
August 19, 2008 at 9:56 am
Thank you very much Toolman. That was my problem.
Jacqueline
August 19, 2008 at 10:13 am
YVW
[font="Comic Sans MS"]toolman[/font]
[font="Arial Narrow"]Numbers 6:24-26[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply