Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS Rows to Columns 1

Status
Not open for further replies.

mhoward01

Programmer
Jul 25, 2011
3
US
I have table

place time
Place1 0800-0900
Place2 0500-0600
Place2 0600-0700
Place2 0800-0900
Place3 0800-0900
Place3 0900-0930
Place4 0800-0900
Place5 0800-0900
Place6 0800-0900

The report represent as
Place1 0800-0900
Place2 0500-0600 0600-0700 0800-0900
Place3 0800-0900 0900-0930
Place4 0800-0900
Place5 0800-0900
Place6 0800-0900

Thank You






 
matrix
place as row group, time as column group, time as detail

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top