02-29-2012 05:16 AM
Can I create a prompt on WRS (tied to an IMS and the IMS has an STP) and pass this value as an input to the Stored Procedure ?
This Stored Procedure already has Few prompts defined. And I also want to add one more prompt (defaulted to a value) at the WRS level and send this prompt value as an input to the WRS.
03-09-2012 06:00 AM
Your second statement doesn't quite align with your question. You can certainly add a prompt in WRS in addition to the STP prompts. WRS will use the second prompts. These won't be passed to the STP, but used in filtering your report.
You could also create a prompted STP that links prompts together?