How do you pass an SSRS report parameter to Sage?

It seems you can pass an explicit value in the sql where clause but cannot pass it from a parameter. The only place to further narrow the data is to add it as a filter to the report. Is there a more effecient way? How?

This statement will work:

Select * from  table1 Where ID = 1

This is what am i trying to accomplish

Select * from table1 Where ID = 1 And Lname = @Last

The query fails if done this way so initially i would do the frist query then set a filter to the table with @Last value.

This is fine when dealing with a small table but not feasible when you are looking at millions of rows or a joined tables. IT degrades performance and all.