Monday, September 13, 2010 3:13 PM
I am using VS 2010 and the SSRS that came with it. I am sure its SSRS 2008. Anyway, I added a report file to the project, added an ObjectDataSource and connected this to SQLServer 2008, and display the dataset on the report. The report is using ScriptManager, ReportViewer1, and Report1.rdlc file. I preview the dataset and I have multiple row returned. The problem is I only have one row displayed on the report. Maybe I did a quick and dirty report? What setting of properties did I missed?
Monday, September 13, 2010 3:16 PM
Could you check in the layout of the report, in the table, most probably it would be of the format
Change it to
Also could you make sure that you are using Report items like tables or matrix to display the results, and not just textbox? Because textboxes can display only one value, tables and matrixes can display more than one
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
- Marked As Answer by BlueMarker Monday, September 13, 2010 5:34 PM
Monday, September 13, 2010 3:49 PM
You can even run the SQL Server profiler, pickup the stored procedure with the parameters which have come for execution, and use the same in management studio. This is only to isolate whether the problem is with the procedure or with the report rendering.
Phani Note: Please mark the post as answered if it answers your question.
Monday, September 13, 2010 5:15 PM
Changed to 1=Fields!ColumnName.Value but the result is the same. I draged n drop the field from the DataSet1, of the Report Data on the left, to the Report1.rdlc on the right. What I get is an <<Expr>> of textbox. I did add a Tablix and modified the expression but it only shows only 1 row. Any suggestion?
Monday, September 13, 2010 5:19 PM
Monday, September 13, 2010 5:20 PM
I don't use stored procedures, just dataset, namely ObjectDataSource. It seems SSRS automatically created dataset for me(after I drag n drop ObjectDataSource and bind it) since all I did is drag the field, from the dataset( inside the Report Data section), over to the Report1.rdlc file.
Maybe when I am more comfortable, then I'll experiment further by calling stored procedures.
Monday, September 13, 2010 5:33 PM
You're right. Tablix is more suitable for multirow. I got the multirow to display. Next for me is to call a stored proc, bind, and display. Any quick link/suggestion? I need to know how to do it manually instead of the quick n dirty way.
Wednesday, September 19, 2012 4:14 PMHey i had same issue because i was just dragging and dropping the fields like crystal reports but in sql server reporting it only treats as text box so it does not repeats the value for that so you need to add matrix or a table then choose the column you want to display.