What PHPRunner version do you use?
I apologize for not knowing how to write well your tongue, but I am Italian. I've been using version PHPr4.2 Build 368. I have bought version 5.0 but I can not use it because it behaves in an unusual way on some SQL code. For example, when I create a Report and try to customize it once you save it does not maintain the custom mode but the move PHPr5.0 fields and columns of the Report in its own way and that is in an uncontrolled way. Also, when I try to put a title that is in the report header, when it runs in the browser often gives me the error and are forced to reset the report with parameters by default. All these problems do not occur PHPr4.2. I hope for a Build later that these problems are solved in order to move to version PHPr5.0 I bought along with WebReport. Otherwise, if having any advice from me for standardizing and make reliable php5.0 version would be much appreciated.
We enclosed a sample SQL code on which the report did not reflect the customization:
SELECT
if(set_ind = 'Auto' or set_ind = 'Danni', 'Assitalia', 'Ina') AS Compagnia,
if(set_ind = 'Auto' or set_ind = 'Danni', Set_Ind, 'Vita') AS Set_Ind,
if(set_ind = 'Auto' or set_ind = 'Danni', Prodotto, Tipo_Premio) AS Prodotto,
SUM(Premio) AS Totale_Premi,
SUM(Premio) / COUNT(Polizza) AS Premio_Medio,
COUNT(Polizza) AS Num_Polizze,
AVG(Durata) AS Durata_Media,
SUM(Premio_Polie) AS Poliennali,
SUM(Pz_Polie) AS Pz_Polie,
SUM(Premio_Tempo) AS Temporanee,
SUM(Pz_Tempo) AS Pz_Tempo,
year(Scadenza) AS Anno_Scad,
month(Scadenza) AS Mese_Scad,
year(Scadenza) - year(now()) AS Durata_Residua,
Tipo_Premio,
Zona,
Cod_Prod
FROM polizze
WHERE Set_Ind <> 'Vita' AND Status = 'Attiva'
GROUP BY Set_Ind, if(set_ind = 'Auto' or set_ind = 'Danni', 'Assitalia', Tipo_Premio), Prodotto
ORDER BY if(set_ind = 'Auto' or set_ind = 'Danni', 'Assitalia', 'Ina'), if(set_ind = 'Auto' or set_ind = 'Danni', Set_Ind, 'Vita'), if(set_ind = 'Auto' or set_ind = 'Danni', Prodotto, Tipo_Premio)