SSRS - Is it possible to have detail rows under a

Question

I have a report that currently lists data of a parent and its the details on the same row. So lets say the columns of the parent group take up the first three columns and the details the next three. Currently the first three columns span the height of the combined details rows. So if there are three detail rows the first three columns are one row that spans the height of these three columns. This is how I initially wanted it.

Now what I would like to do is list the first row of the parent group, then under that list the details, then the next row of the parent group and under that its details and so on.

An example just in case i'm not clear

CategoryId and Category Name are the parent columns

ProductId ProductName and Price are the details, and these are linked to the category by a categoryId

I want to display the first category row, then under that each product in this category, then the next category row and under it the products, then the next category etc.

Is this possible?

Thanks, Neil

Answer 1

What you are looking for is called a stepped report. Here is a good guide on how to create one in SSRS 2008: How to: Create a Stepped Report.

From the webpage:

A stepped report shows detail rows or child groups indented under a parent group in the same column, as shown in the example below:

Answer 2

I opted for a solution using sub-reports. So I display the first three columns on the first row, then on the next (repeating) row I have a sub report which takes the categoryId and displays the products based on the ID passed into it. Works as I want it to

Answer 3

I believe you are asking for:

Category 1  | Category A
Product A01 | $1
Product A02 | $2
Category 2  | Category B
Product B01 | $1
Product B02 | $2

You could try placing the matrix/table in a list which is grouped by category

List grouped by category id[
  Table header row [ category id | category name ]
  Table detail row [ productname | product price ]
]

Hope that makes sense. I predominately use SSRS2005 where there are many shortcomings like this (I put tables in lists and header tables in table cells etc etc). SSRS2008 could have another solution.