Search code examples
reporting-servicesssrs-grouping

SSRS identify odd and even rows in grouping

I have a shared stored procedure which as an example provides me with a list of Items and quantities. This list can have the same Item occurring several times.

I am looking to write an SSRS report, grouping at Item level, which I have completed.

The detail of the report is now across 2 columns and currently I have 2 separate tables, one for odd rows (Col 1, 3, 5 etc) and the other for even rows (Col 2, 4, 6 etc).

How can I identify the specific row number of each grouping to allow me add each line to the respective table.

Example Provided list from Stored Procedure

A, 1

A, 2

A, 1

B, 2

C, 2

C, 2

C, 1

I want my report to look as follows (Ignore the ... as this was for spacing only):

Column-A....Column-B

A, 4..............B, 2

C, 5

I am relatively new to SSRS so an example would be much appreciated.

Solution

  • The issue has been resolved and in a roundabout way I now have the correct results.