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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

This Array must be subscipted Error

Status
Not open for further replies.

lthomas6

MIS
Aug 22, 2007
87
0
0
US
I receive this error after I have modified a parameter in my report to allow for multiple values.

This error occurs in the formula field in my report which does the below:
If {?$LOOKUP$10004} = "ALL" Then
"All Companies"
Else
{?$LOOKUP$10004}

This formula is pulled into the Report Header of the report.
 
Change the formula to:

If {?$LOOKUP$10004} = "ALL" Then
"All Companies"
Else
join({?$LOOKUP$10004},", ")

...assuming this is intended to display the parameter selections.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top