MO Store Manager - help with report needed

[Pippo3000]

folks, need some help. installed the demo of store manager because I need to be able to extract vat reports for the fiscal authorities. what I need every month is an overview of the revenue with the associated tax rate, for germany either 19% or 7%. perfect would be such a list with the order values per invoice

 

20.50EUR | 19%

09.00EUR | 7%

43.34EUR | 19%

32.56EUR | 19% etc

 

or even a sum of all invoices with the associated tax rate:

 

3,230.34EUR | 19%

1,193.78EUR | 7%

 

What I tried in the query builder so far is this:

 

Select ps_orders.invoice_date, ps_tax.rate, ps_orders.total_paid
From ps_tax,
 ps_orders

 

but the result then looks like in attached file: I see always the complete order value twice, once with 7% and once with 19%, but never just the portion of revenue which is actually associated to the respective tax rate.

 

thanks

phil