Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Graph Design & Series Post Reply Post New Topic
Author Message
Antz
Newbie
Newbie


Joined: 17 Jan 2013
Online Status: Offline
Posts: 3
Quote Antz Replybullet Topic: Graph Design & Series
    Posted: 22 Jan 2013 at 1:31am
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
IP IP Logged
Antz
Newbie
Newbie


Joined: 17 Jan 2013
Online Status: Offline
Posts: 3
Quote Antz Replybullet Posted: 23 Jan 2013 at 6:51pm
None have any ideas...
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Jan 2013 at 4:11am

sicnce you want to use drill down you have to set up your report with the group structure to support the drill down.fromt here you have to insert sumamry values at the group level. You can then add a chart using the Data type of "group". my system is blocking your image so I am cannot give you aspecific course at the moment.

Here is link of another thread asking simarl drill in questions.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.051 seconds.