Crystal 10 Crosstab not display 2005 data 2

[dbalynne]

I have created a report that has a crosstab. The 2004 data is displaying with my formula but the 2005 is not displaying in the crosstab.

Here is the formula I am using.
{WIP.Wdate} in dateserial(year(currentdate),month(currentdate)-12,1) to_ dateserial(year(currentdate),month(currentdate),1) and {ServiceCodes.SCCodeDetail} in ["100", "110", "120", "130", "135", "140", "150", "160", "170", "172", "174", "180","185","190","191", "200", "210","220", "230", "235", "240", "250", "260", "280","290"];

 

[Turkbear]

Hi,
If I read your formula correctly, the max date ( to_ dateserial(year(currentdate),month(currentdate),1) )is 1/1/2005 so no other 2005 data would be returned.

 

[dbalynne]

How do I correct it?? I did not write this formula. Or is there a better way of doing this total?

 

[Madawc]

If you want everything to date, then use currentdate as your current date. The formual looks like it was written to include just the first of the current month.

Madawc Williams (East Anglia, UK)

 

[dbalynne]

Thanks I got it to work correctly