HI.

I have 2 date fields in database(open->Green and close-->red data) and i need to build a chart by days but in a specific range.  I insert an image to explain.



How to do this in crystal?
I need to fill x axis with values in range (only). I create a field in CR and fill an array with all positions (all days between range)

global datevar array data_final;
local datevar data := {?FDate};
local numbervar inter := DateDiff("d", {?FDate}, {?FTDate});
Local NumberVar i;
local numbervar j;
local datevar aaa;
redim data_final [inter];

For i := 1 To inter Do
(
    data_final := data;
    data := data + 1;
    i= i+1;
);

But i can't use data_final in xaxis of graph? Do you have any idea to solve this problem?

I need a graphic to know how many issues are open by days between range in x-axis but i cannot use this field dates of database.

Thanks


Edited by danielramos - 07 Jul 2008 at 8:48am