Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Two Variables along X-Axis in CR Graph Post Reply Post New Topic
Author Message
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Topic: Two Variables along X-Axis in CR Graph
     Posted: 03 Dec 2008 at 2:50am

I am designing Crystal Report for a web form in VS 2005. I am developing a Temperature graph of Patient using following dataset

 AdmissionId         Date                Time             Temperature
      1                      03-12-2008     6:00 AM             98
      1                      03-12-2008     12:00 PM           99
      1                      03-12-2008     6:00 PM             98
      1                      03-12-2008     12:00 AM           100
      1                      04-12-2008     6:00 AM             98
      1                      04-12-2008     12:00 PM           99
      1                      04-12-2008     6:00 PM             98
      1                      04-12-2008     12:00 AM           100
      1                      05-12-2008     6:00 AM             98
      1                      05-12-2008     12:00 PM           99
      1                      05-12-2008     6:00 PM             98
      1                      05-12-2008     12:00 AM           100

I am using Line Graph to show the graph. Temperature along the y-axis and time along the X-Axis. I want to show date also along the x-axis with time. Note the date should be shown single time against four records.

Thanks in advance for hints and help
   
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 03 Dec 2008 at 6:22am
I don't use graphs, so I am not an expert, but couldn't you look at it as 1 variable, datetime.
 
You could probably create a formula that returns a datetime and use that in your graph.
 
At least it is an idea.
 
Hope it helps.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 03 Dec 2008 at 7:43am
Hi
 
First Group by Date so that you have 4 records per Date Group then you can try creating 3D bar chart ,where you have options of plotting 3 axes.
 
So your Group Axes is Date
Data Axes is Temp which will be common
Series Axes will be Time
 
Cheers
Rahul
 
 


Edited by rahulwalawalkar - 03 Dec 2008 at 7:45am
IP IP Logged
qasimali84
Newbie
Newbie
Avatar

Joined: 14 Oct 2008
Location: Pakistan
Online Status: Offline
Posts: 27
Quote qasimali84 Replybullet Posted: 05 Dec 2008 at 1:46am
Thanks you.

I need line chart in format< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 10">< name="Originator" content="Microsoft Word 10"><> below

Temp%20Chart

I have also email it to you. I am bound to use line graph as it is customer requirement.

Thanks in advance
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.