| Author |
Message |
Sreelekha
Newbie
Joined: 15 Dec 2008
Location: India
Online Status: Offline
Posts: 6
|
  
Topic: Two data parameters on common axis
Posted: 15 Dec 2008 at 12:49am |
Hi All,
i am new to crystal reports 2008.i got a requirement in which i need to take two different data parameters on common x axis.Is it possible in crystal reports??
If possible,how should i do that??
Can anyone help me??
Appreciate ur help in advance...
Thanks,
Sreelekha
|
|
Sreelekha
|
 IP Logged |
|
|
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 15 Dec 2008 at 2:09am |
Hi
Some sample data ,and expected results will be nice......
Cheers
Rahul
|
| IP Logged |
|
Sreelekha
Newbie
Joined: 15 Dec 2008
Location: India
Online Status: Offline
Posts: 6
|
Posted: 15 Dec 2008 at 2:16am |
Hi Rahul,
my requirement is
i have 3 parameters heating degree days and cooling degree days and average demand.
i need to heating degree days and cooling degree days on common x-axis and average demand on y-axis.
These 3 parameters are calculated within time range as (dec 1st to dec 3rd)
Regards,
Sreelekha
|
|
Sreelekha
|
| IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 15 Dec 2008 at 4:31am |
Hi Sreelekha,
What I think is you need to create two separate graphs for heating and cooling details and then overlay eachother in such a way that they seem to be one,Also you can tyr to experiment using the 3D charts....
Is the requirement for specific chart ,please post some sample data ,so that i can playaround and see what is possible.
Cheers
Rahul
|
| IP Logged |
|
Sreelekha
Newbie
Joined: 15 Dec 2008
Location: India
Online Status: Offline
Posts: 6
|
Posted: 15 Dec 2008 at 4:44am |
Hi Rahul,
my requirement is specific for a chart
Here are sample values
HeatingDegreeDays CoolingDays AverageDemand Date
30 20 27 2008-12-1
21 17 30 2008-12-2
25 18 29.5 2008-12-3
i need to have both heating and cooling days on common x-axis and averagedemand on y-axis based on date
Thanks,
Sreelekha
|
|
Sreelekha
|
| IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 15 Dec 2008 at 5:04am |
Hi
You need to group by Date once done ,specify for each month in group options,You can create a 3d riser type chart in which you can have 2 on change Fields and One Summary field
So 2 onchange fields will be
HeatingDegreeDays
CoolingDays
and
AverageDemand will be summary ,create a formula and place the field in that if you don't want to sum the field.
Let me know if 3d riser type chart is what you looking for?
Cheers
Rahul Edited by rahulwalawalkar - 15 Dec 2008 at 5:05am
|
| IP Logged |
|
Sreelekha
Newbie
Joined: 15 Dec 2008
Location: India
Online Status: Offline
Posts: 6
|
Posted: 15 Dec 2008 at 5:19am |
Hi Rahul,
i should not use 3D Riser chart.
i shld be using any of the 2D charts only and try to represent on common axis.
Is it possible to achieve that in crystal reports
Thanks,
Sreelekha
|
|
Sreelekha
|
| IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 15 Dec 2008 at 5:24am |
Ok
Which type of 2D chart you looking for let me know......?
Cheers
Rahul Edited by rahulwalawalkar - 15 Dec 2008 at 5:25am
|
| IP Logged |
|
Sreelekha
Newbie
Joined: 15 Dec 2008
Location: India
Online Status: Offline
Posts: 6
|
Posted: 15 Dec 2008 at 5:35am |
Hi Rahul,
i am looking for 2D area chart.
Thanks,
Sreelekha
|
|
Sreelekha
|
| IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 15 Dec 2008 at 7:22am |
Hi
I think you should be alright using the 2 Area Chart.Let me know...
Cheers
Rahul
|
| IP Logged |
|
|
|
