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
------------------------------
Original Message:
Sent: Mon October 06, 2025 12:00 PM
From: brenda grossnickle
Subject: 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.
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
------------------------------