Crosstabs in Reports

This topic is locked

Crosstabs in Reports		10/11/2006 23:39:46
PHPRunner General questions
K kenlyle author The best would be if the user could do a drag and drop like an Excel Pivot table, but even hardcoded options would be good for a lot of purposes. Please let me know, as this is an important requirement. I think that there are MySQL commands to do crosstabs, so it maybe just a matter of incorporating those into a report. And I know that Access has good tools; currently I download my MySQL database for analysis, but that's manual, labor, and error prone....It would be nice to do these on the web, live. I would like to generate output like this: http://www.nextwavetech.us/graceworks/Crosstabs1.pdf from regular normalized data; people, schools, surveys, questions, answers, etc., do a big join/query, and flip it around by a few different variables. How doable is that? Thanks in advance, Ken


J	Jane 10/12/2006
	Ken, unfortunately there is no report feature in the PHPRunner 3.1. We plan to add this feature to the next PHPRunner version. Here is a workaround. You can create custom views on the Datasource tables tab, edit SQL query on the Edit SQL query tab. Here are the samples: select count(`Satisfaction`), count(`Referral`) from `TableName` group by `ParentAge` select count(`Satisfaction`), count(`Referral`) from `TableName` group by `MaritalStatus` And then customize these Views on the Visual Editor tab.