Report about the sold products 
Author: Алексей Х.
Visited 1838,
Followers 3,
Shared 0
Hello.How can I get information about the quantity of sold product in the last month?
For example:
Product 1 - 5
Product 2 - 12
Thankful in advance for the answer.
Posted on the
Hello X
There are several ways, you could do it.
The simplest ( if you know how ) is to create a sql-script that does the job.
Another way is, to use the database object. You could put it on a protected page and simply link the object to the sold items table. If you check the "export to excel" then you can put the data into e.g Excel and here select and summarize the data.
The best solution would be to use the free REPORTICO software. http://reportico.org/site/index.php
See the demo !
With this you can make reports where you can select ( on dates and ather things ) and you can summarize reports. You can even direct the reports to a PDF.
You can combine ( join ) tables - and it is rather userfriendly. Making a report for just one table is rather easy.
If you only have the need for one report from your database(s), it would maybe be, like shooting sparrows with a canon.
Kind regards
John S.
Author
Hello, John. Thanks for your reply.
"Another way is, to use the database object..." - You mean this?
Hello X
Yes - I do.
The databse object itself cannot select on dates or summarize, but it would be an easy way to bring data to a spreadsheet where you can do these operations.
You have to decide :
1 - The quick way once - and then a more troublesome way every time you need a report ( database object )
2 - The troublesome way once ( setting up REPORTICO ) and then just a click every time you need the report.
You could start with option 1 ( the database object is one of the objects that is worth the price/credits ), and then later install the free REPORTICO.
Kind regards
John S.
Author
Thank you very much.I will try these options.