How to pass prompt values from Insight report to SP

Hi,

When you create a query subject from a store procedure, the wizard should have shown you the input parameters for the SP. In the wizard, the "Value" column is the place where you specify the value you want to pass into the SP. To pass a parameter from a report prompt, you can use the prompt macro function. Here's an example of what your expression for the SP input parameters may look like:

#prompt('Project', 'token')#
#prompt('Release', 'token')#

Note that this assumes the parameter names used in your report is called "Project" and "Release".

Thanks,

Jeff

Hi Jeff,
Thanks. I have already done the same, but these prompt macro pops up as text boxes while running the report. Acctually I wanted Project and Release dropdowns on the prompt page and then when user selects a value from the dropdown, that value should pass to sp parameter.
Hardik