I have created a report that uses a stored procedure and i pass in the name. Based on the name 0 to many records can be returned. If more than one record is returned, the same value is being repeated in all the columns.
For Example:
Name LName Address
Joe Smith 1 Pub Street
Joe Smith 1 Pub Street
When the result set it:
Joe Smtih 1 Pub Street
Jackie Smith 2 Pub Street
Why is the first value repeating and how do i fix it?
I am using reporting services 2000.
Thanks in advance.
For Example:
Name LName Address
Joe Smith 1 Pub Street
Joe Smith 1 Pub Street
When the result set it:
Joe Smtih 1 Pub Street
Jackie Smith 2 Pub Street
Why is the first value repeating and how do i fix it?
I am using reporting services 2000.
Thanks in advance.