Universal Data Source Question

Hello,

We are working on a solution that converts our transactions into second, and third currencies. The solution entails using a series of SQL views that do the calculations for us, creating a data source out of them, and linking a jet report to the data source to return results.

What we're encountering is that the jet function is being converted to a SQL query (middle box when displaying details when a report is being run). This is taking a very long time. Would any/all of the following help decrease run time? What would have the greatest effect? Am I forgetting something?

1. embedding SQL directly into jet somhow
2. trimming the amount of rows in the SQL view
3. reducing the size of the NL function to include only a few filters

The non universal data source version of the report takes a fraction of a second to make a call and return a sum from the database. The universal data source based on views takes about 3 to 4 seconds causing a a run time increase of 15X to 30X.

Thanks for any help on this!

Thomas