Adding month and year to chart using CR XI

[Dausa67]

I have a chart that management wants me to put a month and year at the base of each column. I can not find in Crystal Reports where I can put the date. I have attached a copy of the report.

Clay

 

[IanWaterman]

I assume your X axis is already a date? Otherwise how can management expect you to add a date.

YOu can change x axis to use a formula

@Year/Mth

totext(year(yourdatefield),0,"")&"/"&totext(month(yourdatefield),"00",0,"")

This will group all your dates as

YYYY/MM

You need to do it this way so that months will follow year/ month chronological order.

Ian

 

[Dausa67]

No, for now I am showing all open orders regardless of date. My current chart has 4 columns. At the base of each column they want the current month and below that they want the vendor name. Next month when the report is ran again, they want to capture the time line starting this month. So next month the chart will show two bars per vendor (1 showing March 2009, the other showing April 2009). I hate to say it but I am not sure what my X axes is.

Clay

 

[lbass]

Go into the chart expert and tell us what you see in the "on change of" area and what you see in the "Show value" areas. If they are formulas, show us the content of the formulas.

-LB

 

[Dausa67]

on change of customer name.
show values: @sum
show values: sum of @breakdown 2

@sum: sum({@BREAK DOWN},{@CUSTOMER NAME})

Breakdown 2: if ({@Days }) ="0" then
1 else 0

Clay

 

[Dausa67]

Correction; On change of

@Customer name - A

Clay

 

[lbass]

Please show the content of {@Days} and {@breakdown}, which I guess is different from {@breakdown 2}. You should always show the content of all nested formulas.

-LB

 

[Dausa67]

@DAYS = if ( CurrentDate - {@new complete date} ) < 0 then "0"
else totext((CurrentDate - {@new complete date}),0,"")

@BREAKDOWN 2 = if ({@Days }) ="0" then
1 else 0

I hope this is what you mean by content.

Clay

 

[lbass]

It looks like they are asking to see a monthly breakdown of the activity, I guess based on the {@new complete date}, so add that as another "on change of" field->order->select "print for each month". Make this your first "on change of" field, so that customers are nested within each month.

-LB