Has anyone used the ParamCount report Function in Report Studio?Ã, I am trying to see how many values the user has selected in the prompt.Ã, For intance, (GO Sales & Retailers), Product Line multi-select prompt on prompt page.Ã, Layout calculation in header of the report showing the count of how many product lines were selected.Ã, I thought that is what the ParamCount function is for.Ã, However when it runs I get blank in return.Ã, Here is my calc:
ParamCount(ParamDisplayValue("Product line"))
I see no documentation on this anywhere aside from the standard description.Ã, If you have encountered it or know any other way of doing this please respond.
Thanks all,
To get the number of selected items within a parameter, your layout calculation should be defined as follows:
ParamCount(ParameterName)
For example, if you wanted to know the number of countries selected by the user for the parameter name of parmCountry, your expression would be:
ParamCount("parmCountry")
HTH.
All right Bdybldr!!!
That worked. Thanks a million.
You're welcome...glad it helped.Ã, If your topic is solved, please close it (see the board rules for instructions).Ã, Thanks.