Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

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
0
Mark01
Asked:
Mark01
  • 4
  • 4
3 Solutions
 
mlmccCommented:
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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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
 
mlmccCommented:
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
 
James0628Commented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now