[AccessD] ADP general question ...

I routinely create one monster detail query (now view) with all the fields in it and all the preassigned where conditions and then
base a set or related reports on this view.  I also have between 10 and 20 optional criteria the user can select - some single value
some multi-value.  I then base varying levels of summary, rollup and crosstab reports on this single "Base" query.

I want a general method to pass the criteria to the "Base query" when I run a report based on a view that is solely based in this
base query but may not necessarily need the criteria fields (eg. views with group by and sum functions.

This is going against Sql 7 from an Access 2000 adp.

Based on my understanding now, I would have to put all this into a stored procedure, have all the parameters in it, and with the
Base table being a User Session Table (eg. #Name) being generated first based on the parameters and following TSql code referring to
it.  As this returns a recordset I assume I'd have to make the final sql code return a table.

Any thoughts or hints on problems or ways to do this would be greatly appreciated.

Tom

ps.  I'm using a product called DynamiCube from Data Dynamics and I've fallen in love with it.
      I've programmed a general data cube form and all the rest is data driven.  It allows total
      end user futzing around and then they can export to excel or print a report.

      If you're in the market for this kind of power and flexibility I'd highly recommend taking
      a look at this product - it's about $500 per developer - no license or runtime fees.  It
      works with VB and supposedly Access though I've not had a chance to test it in Access
      yet.