DateTime formula for Cross-Tab Report

[R000k]

Hello,

I am currently using Crystal 9 and I have a cross tab report that is displaying the data like the below:


2008 2009 2010 2011 2012 2013
$5 $10 $10 $20 $50 $50

I need to write a formula that will display the current year going forward so I wrote this formula:

if Year({Table.Date}) >= Year (currentdate) then Year ({Table.Date})

This is the result


0 2010 2011 2012 2013
$15 $10 $20 $50 $50

I need to get rid of the "0" column and I am having a problem writing the ELSE part of the formula.

Any help would be greatly appreciated. Thanks.

 

[Madawc]

If you exclude records that are not in the future, the crosstab will correct itself.

If it is part of a larger report, you could create a subreport, placed in the report header or footer and showing just the crosstab. A quick way to do this is to save the report under another name and then import it as a crosstab.

Note that Edit > Subreport Links allows you to pass parameters, when these are relevant.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

Go to the customize style tab and check "suppress empty columns" and "suppress empty rows".

-LB

 

[R000k]

Excluding the records using Select Expert worked. That was so simple I can't believe that did not come to me. I guess you learn more and more each day. Thanks you guys!