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?