Search code examples
sql-serverreporting-servicesdatagridssrs-2012ssrs-tablix

SSRS Displaying detail data in a grid with two columns

I have a bit of a problem solving this SSRS problem. I was wondering if anyone has done this kind of thing before?

I'm struggling to figure out a way of getting detail data span over two columns. The reason I need the data like this is for printing address labels.

I was thinking of creating some sort of column grouping in the SQL query and then using that in a martix.

Here's a pic of the layout of the data I need

Any ideas? I'm stuck!

Solution

  • you can generate a RowNr in your query and make a Rowgroup using this RowNr

    select ROW_NUMBER() over (order by [address]) - (ROW_NUMBER() over (order by [address])+1)%2 RowNr, [address]

    Then use first() and last() in the fields.