Hey Guys
I'm usually used to write reports in SSRS and would appreciate any help you can offer.
I have raw data as follow: This is a short extract
DATE
|
GL Code
|
Vehicle
|
Description
|
Volume
|
1/2/2013
|
E-6029-T732-409
|
40
|
Forklift Hyster (NEW) 5 Ton
|
48.167
|
1/2/2013
|
E-6029-T732-409
|
116
|
Toyota Landcruiser (8) N
1655 L
|
31.667
|
1/2/2013
|
E-6029-T732-409
|
120
|
Toyota Landcruiser N 296 L
|
63.75
|
1/2/2013
|
E-6029-T732-409
|
132
|
Toyota Landcruiser N 1498 L
|
29.667
|
1/2/2013
|
E-6029-T732-409
|
135
|
Toyota Landcruiser
N 1687 L
|
42.458
|
1/2/2013
|
E-6029-T732-409
|
159
|
Toyota Landcruiser NR
10 N 1886 L
|
30.208
|
1/2/2013
|
E-6029-T732-409
|
160
|
Toyota Landcruiser NR
11 N 1880 L
|
25.583
|
1/2/2013
|
E-6029-T732-409
|
188
|
Nissan NP300 NR:9
(N148808W)
|
65.167
|
1/2/2013
|
M-2001-M405-409
|
5
|
UV 80 Scissor Lift 1600
|
68.208
|
1/2/2013
|
M-2001-M405-409
|
7
|
Cat Low Profile Grader 120 H
|
122.542
|
1/2/2013
|
M-2001-M405-409
|
8
|
Watertruck (New)
|
143.333
|
1/2/2013
|
M-2001-M405-409
|
48
|
Boomer Diesel
|
64.375
|
1/2/2013
|
M-2001-M405-409
|
217
|
Bell Scaller NR 1
|
63
|
1/2/2013
|
M-2001-M408-409
|
20
|
Elphinstone R1600 NR:7
|
124.333
|
1/2/2013
|
M-2001-M408-409
|
22
|
Elphinstone R1600 NR:9
|
128.5
|
1/2/2013
|
M-2001-M408-409
|
50
|
Elphinstone R1600 NR:13
|
411.083
|
1/2/2013
|
M-2001-M408-409
|
51
|
Elphinstone R1600 NR:14
|
382.292
|
1/2/2013
|
M-2001-M409-409
|
25
|
Elphinstone AD40 DUMP TRUCK
|
177.375
|
I have 2 parameter fields on this store procedure
1. Date from and To
2 Gl Code
Now i would like to make a graph that will display each vehicle volume consumption per month.
All these vehicles is grouped by a GL Code and this GL Code is a parameter field. So it should display a bar graph per vehicle per month. So say a GL code have 40 vehicles i want 40 bar graphs that have multiple series for per year/month. Then it should be possible also to drill down on a specific month to obtain the detail volume consumption per day. e.g. I have played around with cross-tabbes but i rly battle would appreciate help