SELECT

JOB

,ZIP

,SUM(pick) AS PickTotal

,SUM([count]) AS CountTotal

FROM

YOUR TABLE NAME HERE

GROUP BY

JOB

,ZIP

ORDER BY

JOB

,ZIP

Jeff Moden's Three Rules of DBA's.

I, DBA?

I'm not sure that soft skills necessarily come with time. Yes, to the extent that you can train yourself not to dribble when you drink, or to hit the...

SSIS!

See article listed on SSC Home page - "5 free hours of training"

http://www.sqlservercentral.com/articles/Training/63567/

Unless I'm misunderstanding your question, it seems that you should be able to manage this with groups.

-Group the report on the lowest common detail (in your case, sounds...

Perhaps a Matrix might be better suited to your requirement, rather than the data table.

I've been searching for the same. Found this fairly hairy workaround - it pertains to SRS 2000, but...

http://blogs.msdn.com/echarran/archive/2005/11/07/489797.aspx

fwiw-I've made a cursory inspection...