| problem in Report [message #396138] |
Sat, 04 April 2009 04:56  |
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
|
Senior Member |
|
|
Hello
Sir, I made a of stock . date wise i add the stock .
I made Report Parameters . There i made two Parameters one is starting date and 2nd is ending date .
I need stock postion from two date . but It show all the date from the bigning.
Thanks
|
|
|
|
|
|
| Re: problem in Report [message #396201 is a reply to message #396138] |
Sat, 04 April 2009 20:59  |
arunn
Messages: 52
Registered: September 2008
Location: usa
|
Member |
|
|
hi friend,
follow the steps:
1. create one lexical reference as p_lexical
2. add the above lexical reference in the end of data model query.
ex; select db1, db2
from your table
where
&p_lexical
3. add the below code in the after parameter form trigger
IF :p_start_date IS NOT NULL and :p_end_date is not null THEN
:p_end_date := RTRIM( :p_end_date,'''' ) || ' 23:59:59'||'''';
:p_lexical :=' "your stock date db column" BETWEEN TO_DATE('||:p_start_date ||',''DD/MM/YYYY'')
AND TO_DATE('||:p_end_date ||',''DD/MM/YYYY HH24:MI:SS'') )';
END IF;
it will work...
arun
|
|
|
|
| Re: problem in Report [message #397276 is a reply to message #396201] |
Thu, 09 April 2009 14:24 |
svk579
Messages: 9
Registered: April 2009
Location: brea
|
Junior Member |
|
|
hey arun
in the code why u added this line:
what is the significance of this line.. i thought this line is not needed...
:p_end_date := RTRIM( :p_end_date,'''' ) || ' 23:59:59'||'''';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
