i have a parameter which allows discreet muliple values in the detail section and have selected selectrion crtiertia to equal the parameter. But it only shows the first selection added, can someone advise
What type of parameter is it? Are you trying to show the results of the parameter selection process in the report header? If so, and if it is a string parameter, use a formula like this:
I found an article which suggested the following which seemed to work:
whileprintingrecords;
stringvar Output:="";
numbervar Counter;
For Counter := 1 to ubound({?AccountSelection}) do(
if minimum({?AccountSelection}[Counter])= maximum({?AccountSelection}[Counter]) then
Output:= Output & minimum({?AccountSelection}[Counter])&chr(13)
else
Output:= Output & minimum({?AccountSelection}[Counter])& " to "& maximum({?AccountSelection}[Counter])&chr(13)
);
left(Output,len(Output)-1)
so this will list the account numbers I want in the detail. But how do I now show associated data with that account eg account name. I tried to create a group based on the formula but it didnt work
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.