Table values

[Bell1991]

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.

 

[Bell1991]

Figured it out - i didn't have my table bound to database (right click and update the dataset) doh!