how can we display particular record by using oracle report

[sarahaman]

hi all
i am new in oracle!
i made one simple form with report and i made one print button
with trigger.(when-button-pressed)
when i press the print button so its giving me whole data,i do not want whole information of the database i want to print particular record..
some one told me use query but i do not know where i place that query.

can anyone guide me how can we display the particular data in PDF format?



here is my print button code:

DECLARE 
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT('REPORT9');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep); 
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') 
LOOP 
rep_status := report_object_status(v_rep); 
END LOOP; 
IF rep_status = 'FINISHED' THEN 
/*Display report in the browser*/ 
WEB.SHOW_DOCUMENT('http://sara:8889/reports/rwservlet/getjobid'|| 
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repserver','_blank'); 
ELSE 
message('Error when running report'); 
END IF;
PAUSE;
END;

i hope so i will get prompt answer


please guide me i am really fed up now.


Sarah

[acoder]

Hi, welcome to Bytes.
@sarahaman
Not if you post in the wrong section. I've moved your thread to the correct place for Oracle questions where you should get a better response.

Please also remember to use code tags when posting code. Good luck!

[amitpatel66]

The output is coming from the oracle report. So in order to filter the records that you dont want, you will need to modify the SQL Query in Oracle Reports rdf file. Doing that, your report will give you only the data that you want.

I hope this gives you an idea on what you need to do exactly. Do post back in case you are not able to understand.

[sarahaman]

dear sir

actually i want to pass parameters form to report i used so many ways to do it but unfortunatly i m failed.I am little bit confused when i give the value to parameter is passing only the same value which one i specified in

plid paravalues number :='10';

but when i remove value 10 then report is coming blank

i do not want to specify value in variable i want it took value from text field the same value what i entered in the text box.
i hope u got me
waiting for prompt answer

sarah Aman

[amitpatel66]

Try this sample code which would help you pass parameters from form to report:

DECLARE
         id_pl            ParamList := NULL; 
    v_repid         REPORT_OBJECT;
    param_list_name    VARCHAR2(30) := 'para_lista';
v_rep             VARCHAR2(100);
 
NREPORT         VARCHAR2(30) := ‘myreport’;
MYWHERE        VARCHAR2(300) := ‘’;
INTESTA_RP        VARCHAR2(300) := ‘’;
BEGIN
       v_repid     := find_report_object(NREPORT );
Id_pl         := GET_PARAMETER_LIST(param_list_name); 
IF NOT ID_NULL(Id_pl) THEN 
DESTROY_PARAMETER_LIST(Id_pl);
END IF;
id_PL         := CREATE_PARAMETER_LIST(param_list_name);
--
ADD_PARAMETER(ID_PL, 'PARAMFORM',     TEXT_PARAMETER, 'NO');
ADD_PARAMETER(ID_PL, 'MYWHERE',      TEXT_PARAMETER, MYWHERE);
ADD_PARAMETER(ID_PL, 'INTESTA_RP',    TEXT_PARAMETER, INTESTA_RP);
 
V_REP  := run_report_object(v_repid,id_PL);
 

Make sure you create a parameters with the same name as the parameter
that you are passing in the parameter list

[sarahaman]

thanks alot i have recoverd its working now.


now i am trying to pass more parameters


thanks for everything


sarah

[sarahaman]

i wonder so many ppl is facing the same problem and no one knows how to start report server in 10g v-10-1-2 including me

everyone is getting the same error:

FRM- 41213: Unable to connect to the report servername



sarah amam