Call reporting!

Dicas e truques sobre Oracle Reports Builder - modo gráfico ou modo caractere, ascii, arquivo .PRT, etc
Post Reply
thebranco
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 61
Joined: Tue, 04 Aug 2009 7:29 pm
Location: santa cruz das palmeiras

Hi everyone, I'm working with Oracle Developer Suite 10g.

I created a form with the Print button and created a report using the Reports Builder with User's Paramentos ...

I would like to press the button. From the form he called me this screen of relevance user's paramentos ...

How do I?

grate

white
SergioLBJr
Rank: Oracle Guru
Rank: Oracle Guru
Posts: 448
Joined: Tue, 16 Jun 2009 3:07 pm
Location: Parobé - RS
Sérgio Luiz Bonemberger Junior
Programador Junior
Parobé RS

[]s

Take a look at this topic
http://en.glufke.net/oracle/viewtopic.p ... runproduct
Move the 'Paramform' parameter for 'Yes' and solve your problem
Cleonice
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 27
Joined: Mon, 23 Nov 2009 10:04 am
Location: SP

Hi, I'm also trying only to use

Select all

run_report_object(report_id)
I perform the forms, click the button to print and receive the message

Select all

FRM-41219 : Não é possível localizar o relatório: ID Inválido
My Forms and Report .Rep Both are in the same directory, I use 10g.
Can anyone help me?
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

Certainly the object mentioned in report_id does not exist ..

Check this .. Check this value
Cleonice
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 27
Joined: Mon, 23 Nov 2009 10:04 am
Location: SP

In the directory where I do forms, I see that you have test_pap.rdf, test_pap.rep, but I can not identify because I receive this message.
The find_report_object is thus encoded:

Select all

report_id := find_report_object('g:\DESEN\Cleonice\Teste_10g\TESTE_PAP'); 
... 
ReportServerJob := run_report_object(report_id);

[/ Code]
victorhugomuniz
Moderador
Moderador
Posts: 1396
Joined: Fri, 01 Feb 2008 2:06 pm
Location: Rio de Janeiro - RJ
Contact:
:D

RPLOPES
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 5
Joined: Mon, 16 Nov 2009 10:50 am
Location: SP
RAFAEL LOPES

Select all

vParametro := ' paramform=no ';	 
	  
vParametro := vParametro || ' P_COD_GRUPO='  ||TO_CHAR(:CTRL.cod_grupo); 
vParametro := vParametro || ' P_COD_ESP='    ||TO_CHAR(:CTRL.Cod_Especie_Titulo); 
vParametro := vParametro || ' P_COD_CAIXA='  ||TO_CHAR(:CTRL.Cod_Caixa);		  
vParametro := vParametro || ' P_DAT_MOV_INI='||TO_CHAR(:CTRL.DAT_INICIAL,'DD/MM/RRRR HH24:MI:SS');		  
vParametro := vParametro || ' P_DAT_MOV_FIN='||TO_CHAR(:CTRL.DAT_FINAL,'DD/MM/RRRR HH24:MI:SS');		 		 		 
                     
EXEC_REPORT('FIN091',vParametro);
cris_oracle
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Fri, 26 Feb 2010 4:45 pm
Location: São Paulo

Rafael, I am seeing that you understand much of reports, see if you can help me, I need to generate several reports in a single PDF file, for your forum experience. I think you will have no problems helping me.

Thanks
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 14 guests