Build reports with predefined report layout but dynamic where clauses

Currently we are using MS Access to build reports in which we seperate the report layout and where clause into two seperate parts. The tables in the Access database are linked tables to SQL server 2008. One linked table contains various report layouts and another linked table contains varioius where clauses for the report layouts. This way, we can have the same report layout shared by various predefined where clauses. When a user submits a report request, we will put together report layout and the where clause and submit it to build the query dynamically via the custom build Access front-end. Then the Access front-end will send the query to our backend SQL server to run and create the report.

I am interested in doing all these in reporting service. Is it possible? I am totally new to SQL reporting service.

w