Graph Design & Series
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18831
Printed Date: 27 Apr 2024 at 10:19pm
Topic: Graph Design & Series
Posted By: Antz
Subject: Graph Design & Series
Date 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
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  |
Replies:
Posted By: Antz
Date Posted: 23 Jan 2013 at 6:51pm
| None have any ideas... |
Posted By: DBlank
Date 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. http://crystalreportsbook.com/Forum/forum_posts.asp?TID=18583 - http://crystalreportsbook.com/Forum/forum_posts.asp?TID=18583
|