Oracle Reports (MOSC)

MOSC Banner

NO MATCH DATE IN REPORTS

edited Oct 2, 2009 8:31AM in Oracle Reports (MOSC) 1 commentAnswered
 oK  I ALL READY GENERATE THE REPORT .JSP

now i am calling the report with form application  ... i add some parameters :

 WHERE_CLAUSE := 'where MIN_COMPA= :compa and  BOL_COMPA = MIN_COMPA and MIN_SUCURSAL = :sucu and BOL_REFERENCIA = MIN_NUMREFERENCIA and  MIN_TIPOMOVIM IN (''018'')  and BOL_FECHA  between to_date(:FECHA1,''DD/MM/YYYY'')  and to_date(:FECHA2,''DD/MM/YYYY'') '    ;
  
     Add_Parameter(lista,'MOVIN',TEXT_PARAMETER,WHERE_CLAUSE); 
     Add_Parameter(lista,'SUCU',TEXT_PARAMETER,:BLK_DATOS.COD_SUCURSAL);
     Add_Parameter(lista,'FECHA1',TEXT_PARAMETER,NVL(:BLK_DATOS.TXT_FECHA_INICIO,TRUNC(SYSDATE,'MM')));
    Add_Parameter(lista,'FECHA2',TEXT_PARAMETER,NVL(:BLK_DATOS.TXT_FECHA_FINAL, LAST_DAY(SYSDATE)));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center