This topic is locked

How do a chart in a report with group field?

4/3/2008 1:25:45 PM
PHPRunner General questions
J
jesusmanuel author

Hello:
I hope someone can help me:
I have a list with group registration ends when a group I want to put a chart with data from that group.
I get the chart, but with the data of the all table
I get just as data group
Sorry but my English is not very good, I hope undestand me.
Thanks.

J
Jane 4/4/2008

Hi,
unfortunately you can't pass groupID to the SQL queries of the all charts on the report page.
As workaround add link to the chart page for every group on the report page and pass groupID value through URL. Then check passed value in the Chart page: Before SQL query event and add where clause to the SQL query.

J
jesusmanuel author 4/7/2008

Hi,

unfortunately you can't pass groupID to the SQL queries of the all charts on the report page.
As workaround add link to the chart page for every group on the report page and pass groupID value through URL. Then check passed value in the Chart page: Before SQL query event and add where clause to the SQL query.


hi
And if I work from advanced search in the report, choosing only one group, do I get data in the chart?

I did a test, I have a menu, an option "Report" and another "Chart" if I run the chart (with an advance searh) and get the results (results "A"), now, I run the report , and in each group report, the chart shown is the results Chart with "A", if I run the report to advance the search Like the Chart, the result is perfect.

OK?

I wonder, How or where can a process that makes automatic, which run the chart with this advance searh and then report with the same advance searh.
Thanks again

J
Jane 4/8/2008

Hi,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.