How come I only see one row of data?

I'm using .NET 2005 Beta, SQL Server 2000, and attempting to create a local report using the reportview control.

I have a very basic report that I created by first dragging the ReportViewer control onto a form, specifying a new local report, and created a dataset. When I specified the report on the reportviewer using the SmartTag, it generated an ObjectDataSource for me.

I dragged and dropped fields from the DataSource window to the Report to specify which fields to display.

Everything works except one thing - the report shows only one row of data. I had expected to see all my rows of data in a summary type report - is this not how the reportviewer works, or am I doing something wrong

If I drag a GridView control onto the form and set it up to use the same ObjectDataSource, I get all 3000 rows of data.

Thanks in advance for any help.

Answer this question

How come I only see one row of data?

Muhsin Zahid U?ur
When an RDLC file is active the Toolbox should contain ReportItems such as Table, Matrix, Chart, List, Line, Rectangle etc.

There are plenty of books about Reporting Services; see:
http://www.microsoft.com/sql/reporting/techinfo/books.mspx
Note that these books are about Report Server. The way you design reports for use with the ReportViewer control is very similar, although the API of the ReportViewer is all new and is not covered in any existing books.
Ken Noland
This is a common question. Answered here: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=19517
Radhakrishnan
Thank you for your reply.

One more question - there are no tools in the toolbox when I have the report form open. Are there supposed to be If not, how am I to put a list in the report

Also - as these are very basic questions I'm asking - is there a tutorial for creating reports somewhere I've searched, but cannot find anything like that. As you can probably tell, I'm very new to using reports with .NET.

Thanks in advance.
How come I only see one row of data?

Answer this question