prompt calculation and multiple selection

[Hsiao]

Hi,

On my Cognos report, I have a value that is calculated from a value passed from a picklist prompt. The value is a concatenated string of values gathered from prior prompts to filter data on the report (since Cognos prompts only allow one value to be passed and I need all the values from previous prompts to use in the where clause of my query) So, I parse it to use each of the values. Snippts are pasted below to illustrate my process:

The filter (partial): Building Category SQFT University ID in (UnivID)

UnivID: substring(BldgNoUnivIDFY, BkslashPos + 1 , LinePos - BkslashPos - 1)
BldgNoUnivIDFY: ?\Prompts\Pick Building?
...(the formula of BkslashPos and LinePos are skipped)

However, it seems that if I calculate the value from the picklist prompt, the prompt will not display as a multiple selection list even if I have the "IN" operator in the filter. Could anyone let me know if there is a way to get around this or is this merely a limitaiton of Cognos and I need to re-design my report scheme?

Thanks in advance.

Regards,
Hsiao