Forms - A dynamic report launcher

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

Comments

[Samir]

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]

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]

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]

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]

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]

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' ) ;