VReport general idea

[Fabian Eschrich]

Hi,

I want to build some new reports and I want to try vreports for this.

But I have no idea how to start for a task like this:

I want an table with statistical sums of our sales per month.
It should look like this:


          Jan    Feb    Mar
Invoices  10     11     12
Amount    1200   1300   1400

Product A 1      1      1
Product B 2      2      3


The data is stored in 2 tables. One table holds records for all invoices, the other table holds all invoice items (each position on the invoices).

I dont know if this can be done by a query.



Mit freundlichen Grüßen / kindly regards,

Fabian Eschrich
FAESCH Software

info at faesch.de
 
Fon:     +49 (0)37206 889293
Fax:     +49 (0)37206 889294
Skype:   feschrich