Good Morning All,
I am working on a custom view, I attached the following SQL to the view
Select _VendorTable.Service Provider as 'Vendor',
_VendorTable.Vendor Code as Vendor_Code,
Concat('<a href="http://10.100.77.18/development/ap/Utilities/_History_list.php?mastertable=_VendorAccounts&masterkey1=';, Test.Account#,'">',Test.Account#,'</a>') as Account,
Test.LastBilled
From
(SELECT _History.Account#,
Max(_History.DateBilled) as LastBilled
FROM _History Group by _History.Account#)as Test
Inner Join _VendorAccounts ON Test.Account# = _VendorAccounts.AccountNum
Inner Join _VendorTable ON _VendorAccounts.VendorID = _VendorTable.Vendor Code
Where datediff(Now(),Test.LastBilled) > 30 and Active = 1
The statement runs fine outside of PHPRunner, I get the correct results in the Results tab of PHPRunner. If I try to select the query designer, I get the following error
PHPRunner was unable to parse your SQL query. Designer tab is not available.
I can live with that. The problem I am having is that if I add a field to the query, it will never show up in the report. Or in any of the configuration windows.
Any ideas?