Visual Studio Reporting Service Reports 2008

Question

I am trying to generate a report that has 2 lines per record(or row) returned by the query. Simply the first row will hold certain fields but before it returns the next row/record..it generates a subrow as you may call it that holds an additional field. Is this possible? I have another idea of doing this and it would be to just add the extra field on the end of the row and wrap the row to fit on the page thus making it appear 2 lines per record/row returned.

I'm a total noob when it comes to using tablix and these reports so details would be great!

Answer 1

In the report designer, right-click on the detail row header (the gray area, should have 3 horizontal lines), and select Insert Row -> Inside Group (either above or below, depending on where you want the row).

This will add a new row to the current group, with the current group being your detail rows. You can then add fields and text to the second row, and both will show up for each dataset record when the report is run.