TOPIC:

Query and Reports 22 Sep 2012 20:02 #3864

sdm7001 Topic Author Offline Junior Member Posts: 20 Thank you received: 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
	Please Log in or Create an account to join the conversation.

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

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	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
	Please Log in or Create an account to join the conversation.

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

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	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
	Please Log in or Create an account to join the conversation.

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

VeCrea Offline Platinum Member Absolute JCook fan Posts: 473 Thank you received: 100	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
	Please Log in or Create an account to join the conversation.

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

sdm7001
Topic Author
Offline
Junior Member
Posts: 20
Thank you received: 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

Please Log in or Create an account to join the conversation.

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

VeCrea Offline Platinum Member Absolute JCook fan Posts: 473 Thank you received: 100	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
	Please Log in or Create an account to join the conversation.

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

sdm7001 Topic Author Offline Junior Member Posts: 20 Thank you received: 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
	Please Log in or Create an account to join the conversation.

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

VeCrea Offline Platinum Member Absolute JCook fan Posts: 473 Thank you received: 100	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 following user(s) said Thank You: sdm7001
	Please Log in or Create an account to join the conversation.

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

VeCrea Offline Platinum Member Absolute JCook fan Posts: 473 Thank you received: 100	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
	Please Log in or Create an account to join the conversation.

Page:
1

Forum

Support forum

FAQ

Query and Reports

Time to create page: 0.099 seconds

“

”

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)