I'm upgrading a system from Access to SQL.

In Access I link the server mdb to a local mdb where a table holds the users parameters. Then when I print a report it filters no problem, even if I run the report manually (though, it is usually displayed through the system of course).

What's the best way to do this in SQL Server?

e.g. InvoiceReport will use qryInvoice and I need it to pick up specific data based on that users choices, e.g. ClientReference

many thanks in advance for your help
cheers
Raz