Hi @emre I managed to create the report with PHP and SQLSRV module for PHP
This is how it is looking
THis will list all sold items per period + recipe of each item and cost of each item recipe also if the item cost is not found in the transaction document the default transaction cost field will be used.
At the end a total cost for all items will be calculated. I will release this code next week under the current post that i already opened (SambaPOS5 Web Interface for Reports) , maybe someone else need this 