Scheduler trigger fails when a parameter has several values

cacodri

Hello everyone,

In my data model I have a data set:

Select *

from v_cobranza

where        Convenio IN (:Convenio)

           and Docto_Tipo IN (:Docto_Tipo)

           and EstadoCobranza IN (:EstadoCobranza)

           and email_1 is not null

Scheduler Trigger:

Select cobranza

from v_cobranza

where        Convenio IN (:Convenio)

           and Docto_Tipo IN (:Docto_Tipo)

           and EstadoCobranza IN (:EstadoCobranza)

           and email_1 is not null

when schedul a report without the trigger, the report work fine, when activate the trigger and the parameter are only one value each also work fine, but when at least one the paramater are several values, the report does not run.

please someone has a solution that can help me

Thank you very much

Carlos