Print Page | Close Window

how to display on X axis only the month

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17409
Printed Date: 31 Mar 2025 at 12:35am


Topic: how to display on X axis only the month
Posted By: amarg
Subject: how to display on X axis only the month
Date Posted: 24 Aug 2012 at 1:47am
Dear all,
I will be short.

     1. data set contain one year with daily value for diferent eintities
  • 4 columns
  • 366 rows
  • first column - date
  • the rest of the columns contain numbers
      2. data set have to be displayed in a graph
  • on x axis date
  • on y axis numbers
 Issue:
 I whish to display on x axis only the month name not all days. For example in Reporting Builder this could be done specifying the interval type as month and not all the values will be displayed, but just the month name.

Thank you for any answers!


Replies:
Posted By: z9962
Date Posted: 24 Aug 2012 at 2:03am

is your graph been created using the Advanced layout or Group layout?

Posted By: amarg
Date Posted: 10 Sep 2012 at 1:12am
With advanced layout.

and want to look like this on X axis, even the value displayed are for each individual day:

|
|------|------|------|------|------|------|------|------| .....
  Jan    Feb  Mar .....

Posted By: z9962
Date Posted: 13 Sep 2012 at 11:43pm
If you can not use Group layout, then create a new formula Month
MonthName(Month({DATE FIELD}),true)
 
Then use this formula on the X axis, then do a specified sort so that it is displayed Jan, Feb, etc...


Print Page | Close Window