question

rbarrin3 avatar image
rbarrin3 asked

Report only displaying first row

I have an SSRS with several fields including Comment and Position. Position can have one of three values (A, R, or Z). The tablix is only displaying the Comment field. It should show all comments for Position A on one page, R on the next page, and then Z on the last one. It does that part correctly, but only shows the first comment for each Position on the page. I can run the stored procedure in Query Designer and all rows return correctly. The expression in my tablix to show the field is =Fields!Comment.Value, so it is not limiting only on the first record. I have no filters set up.

Anyone have an idea?

ssrs-2008sqlservertablix
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.