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:

Expand|Select|Wrap|Line Numbers

 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.

Quote:

Originally Posted by sarahaman

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

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:

Expand|Select|Wrap|Line Numbers

 
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

how can we display particular record by using oracle report

re: how can we display particular record by using oracle report

re: how can we display particular record by using oracle report

re: how can we display particular record by using oracle report

re: how can we display particular record by using oracle report

re: how can we display particular record by using oracle report

re: how can we display particular record by using oracle report

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about