Recent content by vchen7

Hi, I ran through the problem when running a reports from a forms via RUN_REPORT_OBJECT. This concerns the length of the parameters (REPORT_OTHER, REPORT_DESNAME, REPORT_FILENAME), I passed to the reports with SET_REPORT_OBJECT_PROPERTY. The sum of the 3 lengths could not exceed 244. There...

Hello, what is working : I call reports from forms. In every reports, in before-report trigger, a dialog box pops up, using srw.message(). When from a forms, I call a reports "preview", it does show the dialog box srw.message() what is not working : When from a forms, I call a reports "file"...

Hi nagornyi, Thanks for reply. I finally used formula column in which I recalculate without using any other summary columns, using database columns only. This is a bug that has no solution. Vincent

Hi, I have a problem with my matrix. The following matrix is working fine : |Based Column | Repeating Cols | Sum of repeating cols | Formula ------------------------------------------------------------------------------ | A | B1 | B2 | B3... | Sum(B)...

Hi sem, I have found a solution. In the forms running the reports, add the command-line parameter recursive_load=no as follows : " declare repid REPORT_OBJECT; v_rep varchar(100); param_string varchar2(400):= null; filename varchar2(15):= 'MY_REPORT'; begin repid :=...

Hi, I run reports from forms with something alike : " set_report_object_property(repid, REPORT_OTHER, param_string); v_rep := RUN_REPORT_OBJECT(repid); " I call a reports from the forms, this reports call in Before-Report Trigger, a function in a library LIB-REP, attached to this reports. When...

Thanks Tatips for asking, I had the same trouble. Even though I could pass in the Select 2 count distinct emp_id, I needed one emp_id for a sub-query. Vincent

Hi Dima, wow I guess you had some hard time at your beginning in Forms unless you (and you surely do) speak english when sending requests in forums Thanks for the tip, I just "found out" that my forms_path and reports_path target the same directory for libraries. Well, I do not have the access...

Hi Dima, Thanks a lot for your patience and interest. I did not think of that way, so thank you very much for the tip. But I got a problem. I created two libraries named ALERT (not in the same location). I then use my "common" library LIB. Let us remember that LIB must be attached to every...

Hi draganp, thanks for the tip even though I haven't gone through the case yet But, I shall remember cheers, Vincent

hi nagornyi, thanks for the tip. I have always come through this problem because I sometimes use network drive with a " " blank space in name, and always did I have to copy/paste the source in local drive to modify But here, it would have showed error message : REP-0157 : the value for...

Hi Dima, Thanks again for reply. bypass : I meant avoid using srw.message and srw.program_abort replace commands by stubs : Can you explain me a stub and the usage please? Why I need : I attached a library LIB to every forms/reports I would like to show error and exit a forms/reports in a...

Hi Dima, thank you for your response (and moreover fast) it looks nice a solution next to it, I am looking for a way to bypass srw.message and srw.program_abort. Vincent

hi all, I try to use reports (functions : srw.message and srw.program_abort...) in a procedure PROC_REP and forms (exit_form and show_alert...) in a procedure PROC_FMX Both procedures PROC_REP and PROC_FMX are stored in a library LIB. This library LIB is attached to reports and forms. When I...

hi nagornyi thnx for the reply I just found out why compiled libraries using forms compiler instead of reports converter Vincent