Cognos Analytics

 View Only
Expand all | Collapse all

Cognos Report Studio Search and Select Prompt with Multi-Select - does not have option to move selected items to list box on right

  • 1.  Cognos Report Studio Search and Select Prompt with Multi-Select - does not have option to move selected items to list box on right

    Posted Thu June 08, 2023 01:01 PM

    Re: Cognos Report Studio Search and Select Prompt with Multi-Select - does not have option to move selected items to list box on right

    below is the screen print in the design mode, and then when the report is run. Why is the control changing from the one in design, where you check your items and then click the right arrow to move them to the selected list box, to one that just has checkboxes?

    in design mode

    when report is run 



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------


  • 2.  RE: Cognos Report Studio Search and Select Prompt with Multi-Select - does not have option to move selected items to list box on right

    Posted Thu June 08, 2023 01:28 PM

    Which version are you running? I think you're running into a bug with one of the earlier 11.1 versions. Try changing the Report styles version.



    ------------------------------
    Paul Mendelson
    ------------------------------



  • 3.  RE: Cognos Report Studio Search and Select Prompt with Multi-Select - does not have option to move selected items to list box on right

    Posted Fri June 09, 2023 03:34 AM

    Hi, Brenda, I guess the following is the case: You have a mixed usage of single and multi-select of the parameter "Type Code" in the report (e.g. a filter like " ?Type Code? = 'A' "). In this case Cognos Analytics treats the paramter as if you didn't set mult-select for the search prompt. 



    ------------------------------
    Philipp Hornung
    Business Intelligence Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------



  • 4.  RE: Cognos Report Studio Search and Select Prompt with Multi-Select - does not have option to move selected items to list box on right

    Posted Fri June 09, 2023 09:33 AM

    We are using 11.0.13 LTS. Originally the report style was set to 1, but there was no change in the prompt when we changed it to 11.x. 

    Also, the filter is set to 'in' not '='



    ------------------------------
    Elizabeth Johnson
    ------------------------------



  • 5.  RE: Cognos Report Studio Search and Select Prompt with Multi-Select - does not have option to move selected items to list box on right

    Posted Tue June 13, 2023 03:21 AM
    Edited by Marc Reed Tue June 13, 2023 03:39 AM

    It could be the bug that Paul has mentioned. We encountered this bug on an early upgrade from C10.

    Either try changing your report to a non-interactive report. On the properties panel where you have changed the report styles there is a setting called 'run with interactivity'. Set this to No.

    Or use the 11.4 style - on early versions this is the only style that seemed to render a better prompt for us.

    Or it could be what Phillip has suggested.

    Is that the only place you use that ?Type Code? parameter within your report? Are you using it in a data item to try and show the user what was selected?

    As Philipp has said, it looks like Cognos has found somewhere in your report that the parameter is a single value, rather than a list of values so it changes your prompt.

    A quick test of this would be to delete your prompt page, then run your report. Cognos will auto generate a prompt page based on what parameters it finds within your queries. It will auto generate a prompt for ?Type Code?. Is this auto generated prompt a single select or multi-select?

    Another test would be to delete the prompt page and the filter. Does the autogenerated prompt page still ask you for ?Type Code? if it does then the parameter is used elsewhere in the report.



    ------------------------------
    Marc Reed
    ------------------------------