This topic is locked
[SOLVED]

 Reporting over a joined table

4/24/2015 11:35:15 AM
PHPRunner General questions
N
nickgom author

I am really excited about PHPrunner but I have hit a brick wall. I am using it over Sugar Opensouce which does not have a report writer. Tip for Sergey if you built a sugar module/template you would make money.
I have joined two tables and want to use all the fields in both tables to report on. However this does not seem posible. All I can do is have the two tables in the report and the select one and all its fields and then the other.
Does anyone have any experience of joining two tables and reporting on all the combined fields at once.
I am using the current version of PHP Runner
Thanks
Nick