problem with arrays in formulas

[ub1234567]

Hi everyone,

i am beginners in crystal XI.

i have one problem with arrays in formula.

my columns displays is like this --

column1
2001
2001
2001
2001
2002
2002
2003
2003
2003
2004
2004

actually i want to display distinct years in ascending order.
i have one logic that i can use current raw and compare with next raw year using next function.
but when there is a differant year in two consecutive raw then i want to store that raw year in one array formula.

so that at the end i can put that formula in report footer section so
it display distinct year in ascending order.

any help is appriciated.

 

[Madawc]

You can group on years, and also do totals for the group.

If you're wanting to compare the totals for years, that is harder. The easiest way is to have a set of running totals, one for each year. But note that they won't have the correct totals until after all of the data has been printed.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

What datatype is your field?

-LB

 

[ub1234567]

hi lbass,

i have number datatype
thanks lbass

 

[lbass]

Place a formula like the following in the detail section:

whileprintingrecords;
stringvar array x;
numbervar i;
numbervar j := distinctcount({table.year});
if not (totext({table.year},0,"") in x then (
i := i + 1;
redim preserve x[j];
x := totext({table.year},0,"")
);

Then in the report footer, use a formula like this:

whileprintingrecords;
stringvar array x;
join(x,", ")

-LB

 

[ub1234567]

hi Lbass,

thanks for given me reply.

if not (totext({table.year},0,"") in x

but in above statement, there is no value in X.
how if part looking for value in variable x ?

numbervar i;

and also do we need to assign initial value ot i variable ?

like numbervar i = 0;

your help is appriciated
thanks.

 

[lbass]

All you need to do is substitute your year field for {table.field} and the formulas should work as is.

Re: the clause: if not(.....in x), x has a value after the first record, and this is how you only add distinct values.

You do not need any initialization formulas.

-LB