Pass query item to parameter of Stored Procedure

[Filip.Cuppens]

Hi Guys,

has anybody ever tried to pass the value of a query item to a variable of a stored procedure query ?

Perhaps a small (fictive) example to give you an idea of what I'm trying to achieve: we have a stored procedure which makes soe calculations based on a parameter which asks for a product number. We would like to be able to have the user for instance create a report for a product line, and then the report will show all products for that product line (from a regular query subject), and besides each product the resulting calculations from the stored procedure.

Any help will be appreciated

Regards

Filip