2. PHPRunner General questions
  3. Using this graph script on a report page
This topic is locked

Using this graph script on a report page

 		10/29/2009 8:15:28 AM
PHPRunner General questions
C
 chinwag author

Hi
I want to use the graph code on this page to create a bar graph on my report page:
http://www.qualitycodes.com/tutorial.php?articleid=20
I can get the graph to show up using the 'jan,feb,mar......' example as given on that page, but how do I feed in the values off my report page so the graph shows my actual data held in the report?
I have a field called SITE that contains the location where people are from. e.g. site 1, site 2..... site 5. and a field called VALUE that contains how much things are worth.
How do I use the {$SITE_grval} from the report page and the {$groupSITE_totalVALUE_sum} on this graph?
J
 		Jane 10/29/2009

Hi,
I recommend you to have a look at the PHPRunner built-in charts:

http://www.xlinesoft.com/phprunner/docs/create_chart_and_set_parameters.htm
C
 		chinwag author 10/29/2009

Hi
I am not convinced that the copyright licence will extend to my uses? I am designing a website for a client, who will pay me for the site. Surely I would have to buy a licence from the AnyCHart?
Sergey Kornilov admin 10/29/2009

AnyChart license is included with PHPRunner purchase. There is no need to buy anything extra.
C
 		chinwag author 10/29/2009

really?! they charge $6000 for the privelege for anyone else.
excellent thanks.
C
 		chinwag author 11/1/2009

OK, with this charting module how do you make a chart of a report?
I currently have a report that 'sums' things up for me into totals for each of my categories. The chart function will only allow numeric fields... I only have my autoincrement ID field as numeric. So I want to actually make a chart using the 'sums' from a report.
J
 		Jane 11/2/2009

Hi,
edit SQL query on the Edit SQL query tab for this purpose. For example, add aggregate functions, Order By statements, etc.

Here are some samples:

http://www.xlinesoft.com/phprunner/docs/using_sql_to_shape_chart_data.htm