If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Convert parameter values to query field

Started by SCI Guy, 19 Jan 2017 08:23:07 AM

Previous topic - Next topic

SCI Guy

In Report Studio 10.1.1, I want to take a multi-select parameter and use it as a query field for further manipulation.  I know I can use a layout calculation, but that can't be used in the query itself so I can't do anything further with it in the query.

Any attempt to show the value of a parameter only shows the first value.  That or I get parsing error message.

So, what am I trying to do?  my report has page break on field 'x'.  'x' is a multi-select input parameter.  I want the report to sort on the order that the parameters were entered, not their alpha sort.  If I can get the position of 'x' in the parameter list, then I can figure out how to sort.

Appreciate any feedback.