Monthly Report
556907Feb 27 2007 — edited Feb 28 2007hi dear
using report6i , i would like to know if how to call the monthly report.
my problem is in my database the format of all the records insert is , DATE is "dd-mon-rr" so when i want to call the monthly report example , report for january no records display..
in report query i put like this..
select book.name,book.code,to_date(Book.book_date,'MMMM') from
book
where book.book_date=:Monhtly_Report;
can anyone advise me how to do it..
tnx in advance