Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need tip to write a formulae

my report looks like this :

SelectionCritera:ProductID is '10' and AccountID is '00000' and city is 'VA'

-


ProductID AccountID City

-


10 , 0000 , VA

can somebody tell how to write the formulae(logic) for the SelectionCritera to be displayed as shown above, in crystal and one more thing all ProductID ,AccountID and City have promts on them.

Thanks In Advance.

replied

Hi Sai,

I tried your formula but there are some mistakes in it.

I modified it. Please try the following as it is. it is working at my end when I tried with multi valued numeric parameter.

stringVar array arr1;
stringVar selection;
numberVar i;
redim preserve arr1[count({?ProductID})];
for i:=1 to count({?ProductID}) step 1 do 
arr1<i>:=totext({?ProductID}<i>);
selection:= 'ProductID is : ' & chr(39) & join(arr1,",") & chr(39);

Please check the parameter name is correct or not.

Regards,

Raghavendra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question