image
SALES ANALYTICS VirtueMart Reports: Sales, Products, Orders, Customers, Locations, Manufacturers, Inventory, Taxes, Shipping Costs, ... everything under control on your online shop!! Read the Full Story
image
SALES ANALYTICS for MAGENTO Magento Reports: On-site reports for Sales, Products, Categories, Orders, Customers, Locations, Taxes, Shipping,... deep insight into your Magento online shop!! Read the Full Story
image
SOCIAL ANALYTICS JomSocial Reports: Now you can know about your user social activities in detail. Friends, groups, photos, videos, ... reports on all your user participations. Read the Full Story
image
WEB ANALYTICS Joomla! Reports: You can check how your website is evolving using all the relevant information at hand, and make it grow accordingly!! Read the Full Story
* * * *
image image image image
Welcome, Guest
Username Password: Remember me
SOCIAL ANALYTICS Pre-sale Questions.
  • Page:
  • 1

TOPIC: Creating your own reports

Creating your own reports 6 years, 2 months ago #1

  • drasko
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Hi!

Is there a chance that one that is using your component can create reports on his own or just use existed ones and change them with different sql or something?

I'm asking since I have data in other tables than those that are created and maintained by VirtueMart?

Re: Creating your own reports 6 years, 2 months ago #2

  • latitudweb
  • OFFLINE
  • Administrator
  • Posts: 182
  • Karma: 1
Hi drasko,

Thanks for your interest in our products.

Yes, sure. If you feel confortable with SQL and know how it works, you can slightly modify the SQL queries to also include the data stored on other tables.

Sales Analytic reports basically work with two SQL queries: one query for the header (the report totals overview), and another one for the Graphic display and the detailed table. If you know what you are doing, you can modify these two SQL queries to include other data.

For example, let's say you have a new table (let's call it jos_vm_product_additional_info) with a field named product_cost, used to handle product cost and thus, sales profits. You could modify the SQL queries adding a new field in the query:
... SUM((o.product_item_price-a.product_cost)*o.product_quantity) AS profit ... 

And a new LEFT JOIN to combine the new table:
... LEFT JOIN jos_vm_product_additional_info AS a ON a.product_id=o.order_item_id ... 

If you need any guidance on that, please let us know.

And if you don't feel like modifying the SQL, but still want this customization done, we can do it for you. If you send us the details (you can contact us at info@latitudweb.com) we'll send you an estimation of how much it'd cost, ok?

Kind regards, and again, thank you for your interest in our products.
  • Page:
  • 1
Time to create page: 0.21 seconds

About Us

Latitud WEB is a trademark from Business Excellence through Information Technologies S.L. (BEIT). BEIT is an Information Technology company based in Valencia (Spain). Our aim is to put the IT advantages at the service of companies and organizations of any size.