Well, having runtime parameters would be a nice to have. Having said that, I can't think of any that I need. The query is somewhat complicated, so I can't just run a regular vfp report that filters a table, either. (it has two columns that result from different where clauses. With Oracle i'd just use subqueries for those columns, but with vfp I had to use a union select that dumps into a cursor, another query to sum them into single rows, dump that into a cursor, and a final query to filter for the rows that are actually significant. Actually I might have had to do that last step with Oracle as well. The point being that I need to report on the results of the query as opposed to anything I could do with the report designer (it seems to insist on just grabbing columns from tables and adding filtering and grouping criteria).

noah