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.
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?