Search code examples
sqlreportservicenow

Multi-Row Per Record SQL Statement

I'm not sure this is possible but my manager wants me to do it...

Using the below picture as a reference, is it possible to retrieve a group of records, where each record has 2 rows of columns?

So columns: Number, Incident Number, Vendor Number, Customer Name, Customer Location, Status, Opened and Updated would be part of the first row and column: Work Notes would be a new row that spans the width of the report. Each record would have two rows. Is this possible with a GROUP BY statement?

Record 1

Row 1 = Number, Incident Number, Vendor Number, Customer Name, Customer Location, Status, Opened and Updated

Row 2 = Work Notes

Record 2

Row 1 = Number, Incident Number, Vendor Number, Customer Name, Customer Location, Status, Opened and Updated

Row 2 = Work Notes

Record n

...

PDF Export

Solution

  • I don't think that possible with the built in report engine. You'll need to export the data and format it using something else.

    You could have something similar to what you want on short description (list report, group by short description), but you can't group by work notes so that's out.