Home » Developer & Programmer » Reports & Discoverer » problem in Report
problem in Report [message #396138] Sat, 04 April 2009 04:56 Go to next message
haider_1pk
Messages: 85
Registered: March 2009
Location: PAKISTAN
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 #396180 is a reply to message #396138] Sat, 04 April 2009 12:47 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Hi

I think you present your table sturcture and post your question in SQL forum.


-Dude
Re: problem in Report [message #396201 is a reply to message #396138] Sat, 04 April 2009 20:59 Go to previous messageGo to next message
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 Go to previous message
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'||'''';
Previous Topic: Images in Report Qtn
Next Topic: Searching reports
Goto Forum:
  


Current Time: Sun Dec 11 04:01:13 CST 2016

Total time taken to generate the page: 0.21971 seconds