Crystal Chart Horizontal Axis

The chart in the screenshot shows several blood pressure readings. I’m working with Crystal Reports 2008. The database is Access 2010.

How can I change the horizontal axis so that it displays the date and time of each blood pressure reading?
Line ChartChart Design
Mark01Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Try putting the DATE field in the box under FOR EACH RECORD

If that doesn't work then use ON CHANGE OF instead of FOR EACH RECORD

mlmcc
0
 
Mark01Author Commented:
The date and time are now on the horizontal axis, but the wrong date is displayed. How do I format the date?
chart.jpg
design.jpg
0
 
mlmccCommented:
What do you mean the wrong dateis displayed?

mlmcc
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mlmccCommented:
You put the time on the report.  It probably doesn't have a date associated with it except the default date which it is displaying

mlmcc
0
 
Mark01Author Commented:
The table has both a time and date field. The time and date are entered for every blood pressure reading. The screenshots shows the time and date fields.
fields.jpg
table.jpg
0
 
mlmccConnect With a Mentor Commented:
You only put the time field on the chart.  Most databases don't have a time datatye but simulate it with a datetime field with th edate ignored or set t day 0 which is generally 30 Dec 1899

DateTime(Date{tblBlood_Pressure.Date}), Time({tblBlood_Pressure.Time}))

Use that for the field in the chart

mlmcc
0
 
Mark01Author Commented:
I created a formula for the date and time, but I get an error. See the attached screenshots.

I used the following formulas:
DateTime(Date{tblBlood_Pressure.Date}), Time({tblBlood_Pressure.Time}))
DateTime((Date{tblBlood_Pressure.Date}), Time({tblBlood_Pressure.Time}))
Error-1.jpg
Error-2.jpg
0
 
James0628Connect With a Mentor Commented:
mlmcc left out the "(" after the Date function.  Try this:

DateTime(Date({tblBlood_Pressure.Date}), Time({tblBlood_Pressure.Time}))

 James
0
 
Mark01Author Commented:
It works! Thank you, mlmcc and James0628.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.