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.
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.