Server filters are great if you need to filter the data from a table or view. However, they don’t work if your recordset is an in-line function or a stored procedure. Fortunately, in-line functions and stored procedures can use input parameters to control the data they return.
When you use a parameter query as the record source for a report, you can let Access prompt the user for the parameters when the user opens the report. However, reports in an Access project also have an input parameter that allows you to specify an alternative way to resolve parameters that are required in the in-line function or stored procedure that serves as the report’s record source.