What type of CRReport to use

I need to create a report from 3 tables. One of the table names will remain the same, but the other 2 table names need to be changed at runtime. They have the exact structure, I just create 2 new tables with different names.

What type of report should I use, SQL, ADORecordSet or what?

I have a working sql query, but it's kind of long.

It's for a web app.

What I suggest you do is create a view.

You can pass the table names and parameters to the view and voila.

This is presuming you are using sql server?

If you are using crystal reports you can pass the parameters to the report though code.

think this is what you wanted???

Yea, I'm using Crystal with a native connection. I'll try the params report.

Thanks