My report takes data in the following manner


Client Location Type Size

Clarks NY ****s 6
Clarks NY ****s 7
Clarks LosAnge ****s 8
Clarks LosAnge ****s 9
Clarks LosAnge ****s 10
Clarks LosAnge shirt 38
Clarks LosAnge shirt 39
Clarks LosAnge shirt 40

I need to group and display in such a way that the report displays like the below

Client Location Type Size

Clarks NY ****s 6
                         7
Clarks LosAnge ****s 8
                         9
                        10
Clarks LosAnge shirt 38
                         39
                         40
Basically i need to find the first group in each combination and no display the columns that are repeating in a group.Is there any way i can do this in XSLT.

If you are using XSLT 2.0 then you can simply use the <xsl:for-each-group> instruction.

Otherwise you are looking at the more complicated Muenchina method of grouping:

http://www.jenitennison.com/xslt/gro...muenchian.html

/- Sam Judson : Wrox Technical Editor -/

Is the input data available as XML? Can you show us that XML?
And please state whether you want to use XSLT 2.0 or 1.0 as grouping is much easier with XSLT 2.0.

--
  Martin Honnen
  Microsoft MVP - XML

See the first post in XSLT category for links on grouping, hopefully you're using version 2.0 but it's still possible, although more tortuous, in XSLT 1.0.

--

Joe (Microsoft MVP - XML)

Thanks for your comments.