Issue with Cross-tab

building reports crystal reports
1

Hi,

I have report like displaying Product’s with Manufacturing Year and No.Of units manufactured on that particular Year.

Here is the condition i have to apply:
Top 10 Products with Last 10 manufacturing years, Remaining years should be in a single column as “<=(Latest Manufacture Year - 10)”

Ex: Product/Year 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 <=1998 Total
A 0 2 5 1 9 0 2 5 1 9 0 2 36
B 1 4 2 2 8 1 4 2 2 8 1 4 39
C 3 5 5 3 7 3 5 5 3 7 3 5 54
D 2 6 2 4 6 2 6 2 4 6 2 6 48
E 4 3 1 5 5 4 3 1 5 5 4 3 43
F 5 7 6 6 3 5 7 6 6 3 5 7 66
G 6 1 9 7 2 6 1 9 7 2 6 1 57
Others 2 5 8 8 1 2 5 8 8 1 2 5 55
Total 23 33 38 36 41 23 33 38 36 41 23 33 398

I am trying to achieve the same using cross-tab. Can you please provide how to achieve last 10 years and remaining as <=Max(year)-10 in cross tab.

haisri (BOB member since 2007-08-01)

2

Hi haisri,

Easiest way to achieve that in cross tab is to create a formula fields to group your YEAR…

Formula field for Year: if {year} <= max({year})-10 then totext({year},0)) else ‘>=’ + totext(max({year})-10 ,0)

Then drag the formula field in the cross tab expert and you should achieve what you need…

Cheers!!

hariiu (BOB member since 2007-03-22)