Please help with a date rainge formula for a chart 1

[CrystalKim]

Hi all, I am currently using Crystal 11


I need to make a pie chart in a report based upon a range of dates. The field I need to base it on is the Maturity date (Maturitydt).

Normally I would let Crystal do this in the select expert, but cannot do so in this instance because I need all of the dates for the report itself, but need to define and limite the dates in the chart itself.

I have been trying to do this myself and have not had any luck (using if, then, else).

Is there an easy way to do this? I am beating my head against the wall here, because I am assumng this should be pretty straight forward, but can't figure it out.

Thanks in advance.

 

[dgillz]

So the data in the report is one date range and the data driving the chart is a separate date range? Is this correct?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[CrystalKim]

Thank you for your response.

Yes the dates in the pie chart is seperate from the report. They all share the same date field(aka Maturitydt), but I need to define it in the chart.

Let's say the report itself is based on all dates between 2008 and 2009. I want the report to show that, but I want to segregate the 2008 dates in the pie chart so people know what is going to mature this year.

I hope this makes sense. I am only on my first cup of coffee here this morning.

 

[CrystalKim]

I forgot to mention that the reason why it is going into the pie chart is because I want to break out 2008 MaturityDts by quarter.

Example:

Pie Slice 1: Q1-08 50%
Pie Slide 2: Q2098 25%

etc.

Thanks again.

 

[lbass]

Create a formula:

if year({table.Maturitydt}) = 2008 then {table.amount}

Use this formula as your "show value" field in the chart, and add {table.Maturitydt} as your "on change of" field and while it is highlighted->order->print on change of quarter.

-LB

 

[CrystalKim]

lbass, that worked like a charm.

Thanks!