Date Parameter in Crystal Enterprise 4.0

[Former Member]

I'm using jump link features of SAP BO AOLAP to Crystal Reports.

To pass a date from A OLAP to Crytal, i will have to set DATE Parameter as string.

I'm using a DATEVALUE function to convert my DATE to a String. This works good as long as I dont select "Allow Multiple Values".

When I select the tick mark, System errors to "The Function call does not match any overloads of date".

Please check the attachment. Please assist me on how to convert multiple Single value dates to strings.

Thanks for your help

Karthik V

[abhilash_kumar · Accepted solution]

Hi Karthik,

Could you try this:

{database_field} IN DATEVALUE({?string_parameter})

If this doesn't work, then try this:

datevar array d;

numbervar i;

for i := 1 to ubound({?string_parameter}) do

(

     d[i] := DATEVALUE({?string_parameter}[i]);

);

{database_field} IN d

-Abhilash