[Solved] ParamCount

[cognosguru]

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,

[bdybldr]

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.

[cognosguru]

All right Bdybldr!!!

That worked.  Thanks a million.

[bdybldr]

You're welcome...glad it helped.Ã,  If your topic is solved, please close it (see the board rules for instructions).Ã,  Thanks.