Floating numbers of parameters in reporting from SQL Server 2005 tables

Nov 15, 2008 at 2:35 AM
I am programming with VB.Net and in my recent project which is build on SQL Server 2005, I should build a report interface which includes different parameters to give multiple options to user to build his own report from the target table. My question is "Is it possible to build a stored procedure with floating numbers of parameters ?". If so, I would be able to pass the selected parameters and make a parametrized "SELECT" command.