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.

i hope so i will get prompt answer

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]

passing parameters form to report

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:

[code=oracle]
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_obj ect(NREPORT );
Id_pl := GET_PARAMETER_L IST(param_list_ name);
IF NOT ID_NULL(Id_pl) THEN
DESTROY_PARAMET ER_LIST(Id_pl);
END IF;
id_PL := CREATE_PARAMETE R_LIST(param_li st_name);
--
ADD_PARAMETER(I D_PL, 'PARAMFORM', TEXT_PARAMETER, 'NO');
ADD_PARAMETER(I D_PL, 'MYWHERE', TEXT_PARAMETER, MYWHERE);
ADD_PARAMETER(I D_PL, 'INTESTA_RP', TEXT_PARAMETER, INTESTA_RP);

V_REP := run_report_obje ct(v_repid,id_P L);
[/code]

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]

no body knows how to start report server in 10g.v10.1.2

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