Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter error when selecting Multiple 1

Status
Not open for further replies.

Hillary

Programmer
Feb 15, 2002
377
US
I have a simple parameter that works fine for Discrete or Range values. However, when I select Allow Multiple Values, and run the report, an error occurs, This array must be subscripted. For example: Array

The Select Expert is
{CSL_STD_DEMO_SCHOOL.ACTIVE_STATUS} = "Y" and
{CSL_SET_SCHOOL_INFO.SCHOOL_CODE} in [{?School}]

{?School} is what Crystal highlights when the error occurs.

CR 9.0

Thanks,



Hillary
 
Remove the square brackets, so that it reads:

{CSL_STD_DEMO_SCHOOL.ACTIVE_STATUS} = "Y" and
{CSL_SET_SCHOOL_INFO.SCHOOL_CODE} in {?School}

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top