so I have a formula that looks like this:

    ToText({ProjectedHours.StartDate},{?Pm-?ShortDateFormat}) + " - " + ToText({ProjectedHours.EndDate},{?Pm-?ShortDateFormat})

ProjectedHours is the data source that I'm passing in from C#/.NET. The problem is that it is possible for ProjectedHours to be empty. Is there a way for me to basically to conditionally execute the code above only if ProjectedHours is not empty?

I actually tried this as well. Since I'm using C#/.NET, I can detect if ProjectedHours is empty or not. If it is, I simply set a parameter called HideProjectedHours to true, else false. And in Crystal, I have the following code:

    If {?Pm-?HideProjectedPaidHours} = false Then
    ToText({ProjectedHours.StartDate},{?Pm-?ShortDateFormat}) + " - " + ToText({ProjectedHours.EndDate},{?Pm-?ShortDateFormat})

However, this doesn't work either and I get the error message "Too many arguments have been given to this function. Details: errorKind


Thanks,

Hi,

I just tried that. I got the same error message:

"Error in formula StartDate: 'If not(IsNull({ProjectedHours.StartDate})) Then 'Too many arguments have been given to this function. Details: errorKind"

I would test the formula without the if-then

Edited by DBlank - 23 Oct 2014 at 4:14am