Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Expand all | Collapse all

How to build a report with an input text box that triggers a stored procedure and the text box contents is passed as a parameter.

  • 1.  How to build a report with an input text box that triggers a stored procedure and the text box contents is passed as a parameter.

    Posted 19 hours ago

    I want to build a report where the user can enter text, press a button (or text box just loses focus) and the report definitions would be searched for matching text. Any matches would be displayed in a list: report name, report path, and a preview of the matching text. I know how to search report definitions today and build the contents for the list. What i need is how to create a report with an input text box and how to trigger it to run a stored procedure that is passed the text box contents as an input parameter. 



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


  • 2.  RE: How to build a report with an input text box that triggers a stored procedure and the text box contents is passed as a parameter.

    Posted 5 hours ago

    Hi Brenda,

    In case you have access to the book "IBM Cognos 10 Report Studio Cookbook", Chapter 2 - "Advanced Report Authoring: Writing Back to the Database" - describes something similar. This method does require some work in Framework Manager if you choose to follow it. You will need to import the stored procedure as a "Stored Procedure Query Subject" and then define a macro around it.

    To be honest, I haven't personally tried this yet, but a colleague of mine has had success with it. Please send me a DM if you'd like more information.



    ------------------------------
    Martin Poulsen
    ------------------------------