how to view report in a particular date? [message #89383] |
Fri, 05 March 2004 22:06 |
fatimah
Messages: 9 Registered: February 2004
|
Junior Member |
|
|
Assalamualaikum (2 muslims) n hi 2 everybody..
i need 2 know is it possible to view the report in a particular month. My idea is this, the user is given a date range to be filled in the form, if a user wants to view a 'collection report' in January, he should type in 01 jan 2004 for the 1st date field and in 2nd date field, he should type 31 jan 2004 . As for the system itself, it should retrieve the collection report for 01 to 31 jan 2004 (as the user provided to the system earlier).
i hope it is clear...
thanks in advance...may God bless you all...amin.. ;)
|
|
|
Re: how to view report in a particular date? [message #89386 is a reply to message #89383] |
Sun, 07 March 2004 21:00 |
fanni
Messages: 96 Registered: March 2004
|
Member |
|
|
Wa-alaikum-assalam
Yes u are on the right track.
Define two user parameters in the report
P_FROMDATE OF TYPE date with format mask (dd/mm/yy)
P_TODATE OF TYPE date with format mask (dd/mm/yy)
and include the names in the query with this syntax
date_field between :P_FROMDATE and :P_TODATE
=============================================
I wish this will do your work.
May Allah help u in your tasks.
Regards
Farhan Ashraf
|
|
|
Re: how to view report in a particular date? [message #89398 is a reply to message #89383] |
Mon, 15 March 2004 20:31 |
Kader
Messages: 5 Registered: January 2002
|
Junior Member |
|
|
Wa Alaikkum Wassalam
You have to create two parameters are :p_from_date and :p_to_date. In query, check the condition in where class
particular date BETWEEN :p_from_date AND :p_to_date.
I think,this is enough for solving that problem.
Regards
Kader
|
|
|
Re: how to view report in a particular date? [message #89454 is a reply to message #89383] |
Sat, 03 April 2004 00:42 |
Afroz ahmed
Messages: 13 Registered: February 2003
|
Junior Member |
|
|
you just create two parameter under your query
like this
select ename,sal,hiredate from emp
where deptno = 10
"if you are using a condition then use like this where 1=1 "
&date1
&date2
order by hiredate
now 2 new parameter will created
change the type of parameter into char(200)
and write code in after parameter form
with to_char(' ','mon')
with and clause
|
|
|