Overblog Suivre ce blog
Editer l'article Administration Créer mon blog

Search

Free tool

Look and Feel Project

8 novembre 2005 2 08 /11 /novembre /2005 00:00

This is a tutorial and an Oracle Forms tools that demonstrate how, in a single dialog, to launch any report with 0 up to 10 parameters.

Read the Dynamic Report Launcher

Francois

Partager cet article

Repost 0
Francois Degrelle - dans Oracle Forms
commenter cet article

commentaires

Samir 31/08/2009 12:18

HiI USE ORACLE 8I AND FORMS 6I, I CHANGD YOUR FORMS AND REPORTS TO  6I VERSION WITHOUT PROBLEMS BUT IN DYM_REP.FMB, UNIT DISPLAY LOV,  WHEN I COMPILE, THIS MESSAGE IS AFFICHED:rec_tab dbms_sql.desc_tab2;Le composant desc_tab2 Doit etre déclaré                 THINK YOU FOR YOUR HELP

Francois Degrelle 31/08/2009 12:22


Maybe this function does not exist in Oracle 8i. Try to display this package description to see what functions are available with your version.


Gaetano 21/02/2008 12:45

HiThank You. I have used the forms without modifications. I have changed only the report server.I'm debugging the module and especially the START_REPORT() procedure.The value of variable LN$Params in the section Set the parameters is forever 0. I have tried with both the reports provided.Is this correct ? I suspect no.Can You verify and reply to me.ByGaetano

Francois Degrelle 21/02/2008 14:15

I have done the only modification I said and I can run the both reports EMP and DEPT. one on a file and the other on the cache.

Gaetano 21/02/2008 10:06

Hi Francois,I have used this form. I have installed and compiled all.The form dyn_rep work correctly and in the status bar appear 'ENQUEED'.But no report PDF is created and no preview of PDF is displayed.If I open the Application Server Control Console the job exist and the status is terminated.Can You help me ?Greetings...Gaetano

Francois Degrelle 21/02/2008 10:43

What option of Destype did you choose? cache or file?If you select file, the report is output to a file, so it is not automatically displayed.I have just discovered that if you choose CACHE, then you get an error  while retrieving the file.In the DYN_REP.FMB module, START_REPORT() procedure, change:LC$Target := Nvl( LR$Rec.REP_DESNAME, 'c:\' ) ;toLC$Target := Nvl( LR$Rec.REP_DESNAME, 'c:\report.pdf' ) ;