[thelist] Grouping SQL Report Services

[Rob Smith]

Hi list,

I've got a reporting services report (off of a SQL 2000 Server) that
looks like:
Market Segment					2006
A				Sale			$1000
				Margin		$700
B				Sale			$500
 				Margin		$250
C				Sale			$30,000
				Margin		$20,000
D				Sale			$15,000
				Margin		$10,000

I wanted something like:
Market Segment					2006
Group A			Sale			$1500
				Margin		$950
Group B			Sale			$45,000
				Margin		$30,000


Ok. Is there a way I can group the segments together here at the end?

OR another way to look at this would be to perform some kind of
If-Else/Select in the SQL query upon execution. If Market Segment = A
then Group = A

Thanks

Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org)