How to display all entries from a parameter

[javedi]

Hi Guys,

I have written some code that allows 'All' entries to be included by one option, or a selection of multiple entries. The problem is that only one is shown.

the code is
({AdminNameAddressDetails.StreetDescriptor} in {?Street} or {?Street} = "<ALL>") The {?Street} parameter allows multiple values, but only shows one. Any ideas how i can get all chosen option in the paramter to appear in the report?

Any help would be appreciated.

Thanks

 

[lbass]

If it is a string parameter, use a formula:

join({?Street},", ")

-LB

 

[javedi]

Thanks lbass,

How would the formula need to be implemented?

Thanks
Javedi

 

[lbass]

Go to view->field explorer->formula->new and enter it there. Then drag the result onto the report canvas.

-LB

 

[javedi]

Sorry lbass,

i meant to ask where do i include your formula, would it be in the code i use? or something seperate?

 

[lbass]

I don't understand your question. Aren't you just looking for a formula to display the parameter options that were selected?

-LB

 

[javedi]

Yes your right. But how do i use your formula in the report?

 

[lbass]

I've already explained:

Go to view->field explorer->formula->new and enter:

join({?Street},", ")

Save and close the formula and then drag the result onto the report canvas.

If you are still having trouble, you need to be more specific about what you are doing and what isn't working.

-LB

 

[hann944]

How do you display numeric Arrays?

 

[lbass]

Are you the same person? There is an faq on how to display all kinds of parameter selections. But for numeric parameters, use:

whileprintingrecords;
numbervar i;
numbervar j := ubound({?parm});
stringvar display;

for i := 1 to j do(
display := display + totext({?parm},0,"") + ", ";
);
left(display, len(display)-2)

-LB