Parameter Formula Error: This array must be subscripted

[Former Member]

We are using Crystal XI. I've tried searching the help files in Crystal and have tried to find similar posts in the forum. This is the first time I've written a parameter formula that includes two different date field references. Any help would be greatly appreciated.

I am receiving the error "This array must be subscripted. For example: Array <i>." in the following parameter formula:

{TRACKING_FILE.f463#loan_status} <> "Z" and

{TRACKING_FILE.REGION_ID} <> "CORRES" and

{TRACKING_FILE.f415#approval_date} < {?Approval Date Less Than} and

{TRACKING_FILE.f463#loan_status} in ["W","R"] and

{TRACKING_FILE.f428#reject_withdrawn_date} > {?Rejected Withdrawn Date}

[Former Member · Accepted solution]

Can you tell us which line is hilighted when showing the error message? Also do you have multi value parameter in the report?

Regards,

Raghavendra

[Former Member]

I believe the curser was stopped right before the "Rejected Withdrawn Date" in the formula. I've rewritten the entire formula as follows and I'm not receiving any errors.

{TRACKING_FILE.f415#approval_date} < {?Approval Date Less Than} and

{TRACKING_FILE.f428#reject_withdrawn_date} > {?Rejected Withdrawn Date After } and

{TRACKING_FILE.f426#disbursement_date} > {?Closed Date Greater Than }

Thanks for your help.

[Former Member]

For some reason the post is showing \ instead of a bracket before and after "W", "R" The actual formula has left bracket the "W" then a comma then "R" and then a closed bracket. Sorry.