Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to display on X axis only the month Post Reply Post New Topic
Author Message
amarg
Newbie
Newbie


Joined: 24 Aug 2012
Location: Romania
Online Status: Offline
Posts: 2
Quote amarg Replybullet Topic: how to display on X axis only the month
    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!

IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Posted: 24 Aug 2012 at 2:03am

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

IP IP Logged
amarg
Newbie
Newbie


Joined: 24 Aug 2012
Location: Romania
Online Status: Offline
Posts: 2
Quote amarg Replybullet 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 .....



Edited by amarg - 10 Sep 2012 at 2:07am
IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet 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...
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.035 seconds.