Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table values

Status
Not open for further replies.

Bell1991

Programmer
Aug 20, 2003
386
US
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.
 
Figured it out - i didn't have my table bound to database (right click and update the dataset) doh!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top