Skip to Content
author's profile photo Former Member
Former Member

Parameter Formula Error: This array must be subscripted

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}

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 27, 2009 at 05:04 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 27, 2009 at 04:55 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 27, 2009 at 05:48 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.