|
|
|
|
Re: view the report between two dates [message #471423 is a reply to message #471241] |
Sat, 14 August 2010 03:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ranamirfan
Messages: 535 Registered: January 2006 Location: Pakistan / Saudi Arabia
|
Senior Member |
![ranamirfan@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Dear
try this as a Sample.
WHEN-BUTTON-PRESSED
DECLARE
pl_id ParamList;
pl_name VARCHAR2(50) := 'tempdata';
BEGIN
pl_id := Get_Parameter_List(pl_name);
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List(pl_name);
Add_Parameter(pl_id, 'GrnFromDate', TEXT_PARAMETER, :Grn_header.Pk_GrnF_Date);
Add_Parameter(pl_id, 'GrnToDate', TEXT_PARAMETER, :Grn_header.Pk_GrnTo_Date);
Add_Parameter(pl_id, 'Destype', TEXT_PARAMETER, 'Preview');
Run_Product(REPORTS, '\\atmdomain\irfansoft\Store\Inspection\Reports\GRNote.Rep', SYNCHRONOUS, RUNTIME,FILESYSTEM,Pl_id,NULL);
END;
Hope this'll help you.
Regards,
Irfan
|
|
|
|
Re: view the report between two dates [message #472578 is a reply to message #472570] |
Sun, 22 August 2010 14:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
I see nothing in this thread that doesn't apply to 10g.
If you actually want help you need to give some real information about the problem - details about the report, how you call it and what is happening.
Otherwise you are just wasting everybodies time.
|
|
|