p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 (http://p2p.wrox.com/forumdisplay.php?f=251)
-   -   Hour by Hour Matrix Report (http://p2p.wrox.com/showthread.php?t=70026)

Ed_Conde August 12th, 2008 02:51 PM

Hour by Hour Matrix Report
 
Here is what I want to do. I want to be able to create a report that on the column will display TicketCategory and on each row will display the amount of tickets grouped by Hour. My problem is that I can't find an easy way of grouping the data by hour when creating my matrix.

Here is a sample of the raw data in my dataset:

 [u]
#DATETIME #TICKETCATEGORY #TICKETQTY </u>
08/12/2008 10:05 AM ADULT 1
08/12/2008 10:10 AM CHILD 1
08/12/2008 10:30 AM ADULT 1
08/12/2008 11:05 AM ADULT 1


This is how my report should look like
[u]
#TIME // #TICKETCATEGORY
           #ADULT #CHILD</u>
 9:00 AM 0 0
10:00 AM 2 1
11:00 AM 1 0







All times are GMT -4. The time now is 11:20 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.