Welcome, Guest
Username: Password: Remember me

TOPIC: Query and Reports

Query and Reports 22 Sep 2012 20:02 #3864

  • sdm7001
  • sdm7001's Avatar
  • Offline
  • Junior Member
  • Posts: 20
  • Karma: 0
Is there a query and reporting tool that can be using in conjunction with Cook that integrates with Joomla?

I am interested in queries,reporting, charting and graphing of data within the Cook module.

Thanks,

SDM
The administrator has disabled public write access.

Re: Query and Reports 22 Sep 2012 20:17 #3865

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
amCharts is good.
www.amcharts.com/

For sure google furnish something good also.

Cook do not support Charts for the moment.

Let's discuss here wich one to integrate in the future.
Coding is now a piece of cake
The administrator has disabled public write access.

Re: Query and Reports 22 Sep 2012 20:18 #3866

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
I mean, it is really esay to integrate afterwards.

Once you can manipulate, filter and get your datas, it is a piece of cake to transform them to a javascript plugin such a chart.
Coding is now a piece of cake
The administrator has disabled public write access.

Re: Query and Reports 23 Sep 2012 04:19 #3870

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
  • Karma: 30
I did integrate it with google charts already, and looks perfect... Just need a bunch of code to be added after you generate.
I published that a while ago :
www.j-cook.pro/forum/9-coding-inside-you...mit=10&start=10#1910
The administrator has disabled public write access.

Re: Query and Reports 23 Sep 2012 15:02 #3902

  • sdm7001
  • sdm7001's Avatar
  • Offline
  • Junior Member
  • Posts: 20
  • Karma: 0
I need to be able to produce reports from multiple tables and display them in text format. It would also be good to have a char that could be drilled into.

For example:
Display a client list sorted by revenue and product type over a period of time
Display a marketers efforts over a period of time and their closing ratio

Turn these into charts and reports that are available to management for real time info
The administrator has disabled public write access.

Re: Query and Reports 23 Sep 2012 15:32 #3903

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
  • Karma: 30
All that seems possible, with a little coding after you downloaded your component (or without, depends if the data from multiple tables are fk'ed in the main table or not).
Also, with range filters and ordering, it all looks possible
The administrator has disabled public write access.

Re: Query and Reports 23 Sep 2012 15:38 #3906

  • sdm7001
  • sdm7001's Avatar
  • Offline
  • Junior Member
  • Posts: 20
  • Karma: 0
Thank you very much. Since I am so new to this is there a place you could direct me so I can read and learn?

SDM
The administrator has disabled public write access.

Re: Query and Reports 23 Sep 2012 17:12 #3919

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
  • Karma: 30
Here is the right place man ;)
docs.joomla.org/Developers is a good place to start if you don't know about dev for joomla.
As for cook, just follow the lessons.
Have fun
The administrator has disabled public write access.
The following user(s) said Thank You: sdm7001

Re: Query and Reports 23 Sep 2012 18:18 #3921

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
  • Karma: 30
www.jqueryrain.com/2012/06/attc-automati...google-chart-jquery/
Don't know this one, never tried it, but maybe it could of some help
The administrator has disabled public write access.
Time to create page: 0.106 seconds

Get Started