SSRS Only Display One Row

Question

Hi people,

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?

BlueMarker

Answer 1

Could you check in the layout of the report, in the table, most probably it would be of the format 

=first(Fields!<columnName>.Value)

Change it to

=Fields!<columnName>.Value

 

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

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 2

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.

Regards,

 

---

Phani Note: Please mark the post as answered if it answers your question.

Answer 3

Hi Jason,

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?

BlueMarker

Answer 4

you make a tablix first in the rdlc, and then drag and drop from the dataset to the second row of the tablix (first is header)

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 5

Hi Phaneendra,

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.

BlueMarker

Answer 6

Hi Jason,

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.

BlueMarker

Answer 7

Hey 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.