Report vs Form [message #161997] |
Wed, 08 March 2006 02:35 |
xprime
Messages: 1 Registered: March 2006 Location: Malaysia
|
Junior Member |
|
|
Hi everybody
Please help me as it was making me confuse using report builder.
My problems is a report if I run through the report builder I get the correct output(data) but when I call it from form the report preview show me un-correct record display. Example: generate using report builder i got total pages 2 but using button in form I got 13 pages. Anyone can help ?
Syntax in form :
declare
pl_id ParamList;
begin
pl_id := Get_Parameter_List('disccalrp');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('disccalrp');
Add_Parameter(pl_id, 'ps_date' , TEXT_PARAMETER, to_char(:param.s_date,'dd/mm/rrrr'));
Add_Parameter(pl_id, 'pe_date' , TEXT_PARAMETER, to_char(:param.e_date,'dd/mm/rrrr'));
Add_Parameter(pl_id, 'wk_user' , TEXT_PARAMETER, :user_name);
Add_Parameter(pl_id,'desname',TEXT_PARAMETER,:global.formpath);
Add_Parameter(pl_id,'paramform',TEXT_PARAMETER,'no');
Run_product(REPORTS, :global.formpath||'disccalrp', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL);
|
|
|
Re: Report vs Form [message #169358 is a reply to message #161997] |
Wed, 26 April 2006 07:13 |
ksmbabu
Messages: 9 Registered: April 2006 Location: MALAYSIA
|
Junior Member |
|
|
hi xprime
I hope your code will do the needful. but my doubt is you have not created the rep file properly. after compile from menu
FILE => GENERATE => REPORT EXE FILE. OR PRESS CTRL+T.
BYE
BABU
|
|
|