Recently I have started getting errors in one of our reports. It was working fine and no changes have been made to report o underlying tables. The only thing changed is that we are using 8.3.11 for development
Quote |
---|
Error executing report , reason: Initialization error , reason: Error creating data set "DataSet1" , reason: Error executing data set query , reason: {(9, 2)}: Incompatible types "CASE" <<?>>REFPRESENTATION(RetencionesEnComprasIVATurnovers.Recorder) AS RecorderPresentation |
The query does not have words mentioned in error so it seems like a platform problem.
Query:
Quote |
---|
SEL ECT RetencionesEnComprasIVATurnovers.Period, RetencionesEnComprasIVATurnovers.Recorder, RetencionesEnComprasIVATurnovers.Empresa, RetencionesEnComprasIVATurnovers.Porcentaje, RetencionesEnComprasIVATurnovers.RetenidoTurnover, RetencionesEnComprasIVATurnovers.base0Turnover, RetencionesEnComprasIVATurnovers.baseGravTurnover, RetencionesEnComprasIVATurnovers.baseNoGravTurnover FR OM AccumulationRegister.RetencionesEnComprasIVA.Turnovers(, , Recorder, ) AS RetencionesEnComprasIVATurnovers |