Mar 7, 2006 #1 antmoe3 Programmer Feb 24, 2006 32 US I created a parameter and place it into my report. {?dept} There are three values entered for the parameter. (3,4,5) However, only one value displays on the report (3). How do I display all the values on the report I entered into the prompt?
I created a parameter and place it into my report. {?dept} There are three values entered for the parameter. (3,4,5) However, only one value displays on the report (3). How do I display all the values on the report I entered into the prompt?
Mar 7, 2006 #2 lbass Technical User Feb 9, 2002 32,818 US This assumes your parameter is a number parameter. Create a formula like this: stringvar parm; numbervar i; numbervar j := ubound({?parm}); for i := 1 to j do( parm := parm + totext({?parm}[counter],0,"") + ", "); left(parm, len(parm)-2); SynapseVampire has an FAQ on this topic that you might want to check out also. -LB Upvote 0 Downvote
This assumes your parameter is a number parameter. Create a formula like this: stringvar parm; numbervar i; numbervar j := ubound({?parm}); for i := 1 to j do( parm := parm + totext({?parm}[counter],0,"") + ", "); left(parm, len(parm)-2); SynapseVampire has an FAQ on this topic that you might want to check out also. -LB