This is a migrated thread and some comments may be shown as answers.

SqlDataSource only returning 1 row?

1 Answer 97 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Tim
Top achievements
Rank 1
Tim asked on 15 Jul 2011, 10:41 PM
I have two separate reports that each have a SqlDataSource and are querying a stored proc (different one for each). When I execute the stored proc directly on the database, I get 50 rows. When I execute the stored proc with the same parameters either through the DataSource wizard in the Telerik report designer or querying the report through a web interface, I only get 1 row as a response.

As I mentioned this is happening with two different stored procs. Is there some way to limit results that may be turned on (and I'm missing)?

Has anyone come across anything similar?

Using Reporting Q1 2011
 
Thanks

1 Answer, 1 is accepted

Sort by
0
Tim
Top achievements
Rank 1
answered on 16 Jul 2011, 01:34 AM
Fixed....be careful copying and pasting get/set functions for your parameters...
Tags
General Discussions
Asked by
Tim
Top achievements
Rank 1
Answers by
Tim
Top achievements
Rank 1
Share this question
or