Search Prompt Exclude/ NOT

[teresa.danna@gmail.com]

Hi all -

I've been asked to add a search prompt to the prompt page of a fully functional report that would exclude items. This is what I did:

1)    [PROJ_ID] not in ( ?Parm_PROJ_NOT? )    ----   in the query filter (validation on the detail filter expression comes back as "No errors.") Set it to optional
2)    I then added an additional 'Select & Search Prompt' on the prompt page and mapped it to the above filter, and new prompt query  and object for PROJ.
Query: PROJ
Use Value: PROJ
Required: No
Multi-Select: Yes


When I ran the report and then filtered for PROJ in the new search filter, the search page froze. Anyone have any thoughts as to why it froze or a workaround? Maybe I'm doing something wrong?

We are in Cognos 10.2.2, with a relational database.

[AnalyticsWithJay]

Could you set the "Rows Per Page" property on the prompt to 50? I'm wondering if you're just returning a large volume of data and your browser freezes. I believe the default is 5000.

Also, open task manager and monitor your browser when this happens. Is there a huge spike in memory/CPU?