Simple suggestion, I'm sure there are other more sophisticated options: A checkbox that enables/disables the use of parameters and, potentially, an interface (in the Dataset properties) that supports logic to direct the dataset to use one of a set of optional stored procedures based on the criteria selected ... if users don't want to develop dynamic SQL statements or IF logic blocks.