Conditional Filter

[kutoose]

Crystal Reports 10
Oracle 9

Can we have conditonal filters in Crystal 'Select Expert' ???
This filter is based on parameter.

If the parameter is > 12 then Table.Year = [Year(CurrenDate)]
else
Table.Year = Year(CurrentDate)-1


I cannot use a stored procedure for this report.

Thanks !

kutoose@yahoo.com

 

[question911]

Yes, I use conditions in my selection formulas.

 

[kskid]

//@TableYear
If the {?parameter} is > 12 then
Table.Year = Year(CurrenDate)
else
Table.Year = Year(CurrentDate)-1


Then in your record selection, use the following

year(table.year) = {@TableYear}


Hope this helps

-LW