You will need to build a defined dataset using dynamic sql to union your statements or build a temp table and insert data interatively.

If your dataset contains the columns ID,SequenceNo,ColumnHeading and ColumnValue then you can build a matrix in SSRS with ID for the row, ColumnValue for the column (grouped on SequenceNo) and ColumnHeading for the column heading.