Author Topic: [Solved] ParamCount  (Read 2091 times)

Offline cognosguru

  • Full Member
  • ***
  • Posts: 40
  • Forum Citizenship: +3/-1
[Solved] ParamCount
« on: 03 Feb 2006 03:02:03 am »
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,
« Last Edit: 08 Feb 2006 12:29:39 am by bdybldr »

Offline bdybldr

  • Global Moderator
  • Statesman
  • *****
  • Posts: 275
  • Forum Citizenship: +7/-1
Re: ParamCount
« Reply #1 on: 03 Feb 2006 09:13:22 pm »
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.

Offline cognosguru

  • Full Member
  • ***
  • Posts: 40
  • Forum Citizenship: +3/-1
Re: ParamCount
« Reply #2 on: 04 Feb 2006 02:25:07 am »
All right Bdybldr!!!

That worked.  Thanks a million.

Offline bdybldr

  • Global Moderator
  • Statesman
  • *****
  • Posts: 275
  • Forum Citizenship: +7/-1
Re: ParamCount
« Reply #3 on: 06 Feb 2006 10:00:50 pm »
You're welcome...glad it helped.  If your topic is solved, please close it (see the board rules for instructions).  Thanks.