Home Oracle Sample code shows calling formatted date plus code interact with Crystal Report using API
Sample code shows calling formatted date plus code interact with Crystal Report using API PDF Print E-mail
Written by Siva   
Tuesday, 23 November 2010 10:04

 

select to_char(sysdate,'YYYYMMDD HH24:MI:SS') from dual;

 

between to_date('" & date_var & " 12:00:00 am','mm/dd/yyyy hh:mi:ss pm')

and to_date('" & date_var & " 11:59:59 pm','mm/dd/yyyy hh:mi:ss pm')

 

 

Blue highlighted - shows passing value from Crystal Report. Use API to interact with your program

 

 

select el.event_log_id, el.user_id, el.session_id, el.event_time, el.ip_address, el.report_id,

el.report_name as report_file_name, el.session_log_id, up.username, up.first_name, up.last_name,

rr.report_name, rr.category_id

from genie_rep_event_log el, genie_rep_user_profile up, genie_rep_reports rr

where up.user_id = el.user_id

and rr.report_id = el.report_id

and up.first_name like '%{?first_name}%'

and up.last_name like '%{?last_name}%'

and rr.report_name like '%{?report_name}%'

and el.report_name like '%{?report_file_name}%'

and el.ip_address like '%{?ip_address}%'

and el.event_time between to_date('10/26/2004 12:00:00 am','mm/dd/yyyy hh:mi:ss pm')

and to_date('10/26/2004 11:59:59 pm','mm/dd/yyyy hh:mi:ss pm')

 

 

select el.event_log_id, el.user_id, el.session_id, el.event_time, el.ip_address, el.report_id,

el.report_name as report_file_name, el.session_log_id, up.username, up.first_name, up.last_name,

rr.report_name, rr.category_id

from genie_rep_event_log el, genie_rep_user_profile up, genie_rep_reports rr

where up.user_id = el.user_id

and rr.report_id = el.report_id

and up.first_name like '%{?first_name}%'

and up.last_name like '%{?last_name}%'

and rr.report_name like '%{?report_name}%'

and el.report_name like '%{?report_file_name}%'

and el.ip_address like '%{?ip_address}%'

and el.event_time between to_date('{?StartDate} 12:00:00 am','mm/dd/yyyy hh:mi:ss pm')

and to_date('{?EndDate} 11:59:59 pm','mm/dd/yyyy hh:mi:ss pm')

Last Updated on Tuesday, 23 November 2010 10:16
 
 

Advertisement

Featured Links:
HREmail.com
Looking for job? Try HREmail.com
Want to have CMS based Websites?
Try siliconwebcreators.com to CMS based websites.
VM Solutions Inc
For best VM solutions..
Digital Procedure Inc.
Looking for Oracle /SAP /Weblogic Consulting services? visit digitalprocedure.com