PHPRunner Enterprise 9.8
I have a query that was provided to me. When I paste into PHPRunner I am not able to view on the Design Tab. I get an error stating that PHPRunner was unable to parse SQL query. I am able to publish my application and the query works fine. Any ideas on how to make the query PHPRunner friendly so that I can view with the Design Tab?
My Query
Select pr.shift_date as shift_date, pr.Total_Units as total_units, pr.total_revenue as Revenue, hp.total_hours as Total_Hours, hp.Total_Payroll as Total_Payroll, (pr.Total_Revenue-hp.Total_Payroll) as NET, (pr.total_units/hp.total_hours) as Units_per_hour, (pr.Total_Revenue/pr.total_units) as Revenue_Per_unit, (hp.Total_Payroll/pr.total_units) as Cost_per_unit
FROM
(SELECT shift_date ,Sum(parts+majors+customized+(recrate0.5)+returns+p.rstatus) as Total_Units ,Sum((partsparts_accessories_base)+(majorsmajor_base)+(customizedcustomize_base)+(returns_base(returns0.5))+(recraterecrate_base)+(p.rstatusr.rstatus)) as total_revenue
FROM wp_daily_production as p,wp_transaction_rates as r
where p.DC=r.DC
group by shift_date) as pr
inner join (SELECT shift_date,Sum(Hours) as total_hours ,sum(wages) as Total_Payroll FROM kronos_employee_hours_by_labor_account_daily
where department=293
Group by shift_date) as hp
on pr.shift_date =hp.shift_date
Thanks
Hopper
