order reports from ecart

Is there a way to use the Data Bridge Search Wizard to create a report for Orders?

I need to be able to run a report based on a date range, and view results from the orders table, and orderdetail table, and then sort by my office names, and sales reps (both captured during checkout)

Basically, I want to be able to look at 1 weeks worth of orders, and see the total number of units (sum of qty field on all order details) each sales rep has produced.

Yes, this can be done using the Data Assist Search Wizard.

start by creating a recordset to join the orders and orderdetails tables on the results page, and use an order by clause to order the results by the office names, and sales reps columns.

Add the information you would like to display on the results page and the repeat region so that it will repeat through the recordset.

you can then use the Data Assist search wizard to create the search form to search the recordset you created by the data Range.

Is there a good resource online for learning how to define recordsets? I think I get the general principal behind SELECT, INNER JOIN, but I am unsure on the correct syntax.

Does this look correct?

SELECT *
FROM orders INNER JOIN orderdetails
WHERE orders.OrderID=orderdetails.DetailOrderID
ORDER BY orders.Office, orders.rep_First, orders.rep_last

Sorry, one more question.

Is there a way to export the results to excel or .csv?

yes that looks correct.

w3scools has a decent tutorial for joined queries:
sql_join.asp


To export the results to excell or csv, you would need to hand code that. there are many resources online that talk about how to do that, here is one i found through a google search:
dataexport/