SSRS 2008 Grouping With Header VS2008

Posted by Kevin on Stack Overflow See other posts from Stack Overflow or by Kevin
Published on 2010-06-02T19:53:47Z Indexed on 2010/06/02 20:24 UTC
Read the original article Hit count: 112

Filed under:

I have a table with the following columns and data

  • Category Item Price Tax
  • A I1 1.00 .01
  • A I2 2.22 .02
  • B I3 3.33 0.3

I want to group on Category and have the details below such as:

  • Category/Item Price Tax
  • A
  • I1 1.00 .01
  • I2 2.22 .02
  • B
  • I3 3.33 .03

I want the category to have its own row then the detail rows below with the item in the same column as the Category.

The output that is desired is:

  • Category - Item | Price | Tax
  • A | |
  • I1 | 1.00 | .01
  • I2 | 2.22 | .02
  • B | |
  • I3 | 3.33 | .03

© Stack Overflow or respective owner

Related posts about ssrs-2008