Home/Oracle Reports
  1. Asked: September 15, 2022In:

    Font in RDF

    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    I am wondering why to use a report builder template to create a PDF report layout while you have the XML publisher with all its facilities and the ease to design any template using MSWord. But generally, the update of the character set shouldn't have any impact on the report layout or output. Also,Read more

    I am wondering why to use a report builder template to create a PDF report layout while you have the XML publisher with all its facilities and the ease to design any template using MSWord.

    But generally, the update of the character set shouldn’t have any impact on the report layout or output. Also, is this issue exists in all reports or only in this report? try to delete this repeating frame or create a new one, the same as the one that has the issue, and observe the new one.

    See less
    • 0
  2. Asked: March 18, 2020In:

    REP-0118 unable to create temporary file

    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    Hi @matheo, This REP-0118 error is raise because of issue with temporary file path for report builder that specified with folder that you don't have access to. To fix this issue you have to change temporary path in windows registry by following the steps below:  Navigate to run from Start Taskbar. TRead more

    Hi matheo,

    This REP-0118 error is raise because of issue with temporary file path for report builder that specified with folder that you don’t have access to.

    To fix this issue you have to change temporary path in windows registry by following the steps below:

    1.  Navigate to run from Start Taskbar.
    2. Type (Regedit) without parentheses to open registry window.
    3. Press (Ctrl+F) to search about (REPORTS_TMP).
    4. Finally modify the path to the ones you have access to.

    Hopefully that will help you.

    Best Regards.

    See less
    • 6
  3. Asked: July 3, 2016In:

    REP-52262 Diagnostic output is disabled when using oracle reports 11g

    SaLaZaR

    i found <!–webcommandaccess>L1</webcommandaccess–> inside  the "rwservlet.properties.jmxori" not in  the "rwservlet.properties" what should i do

    i found <!–webcommandaccess>L1</webcommandaccess–>
    inside  the “rwservlet.properties.jmxori” not in  the “rwservlet.properties”
    what should i do

    See less
    • 0
  4. Asked: May 11, 2018In:

    rep-14015 : beforereport unkhown user exit fnd ?

    Best Answer
    Googler Explorer

    The USER EXITS are specific to Applications. Try to check the report in builder by commenting those srw exits

    The USER EXITS are specific to Applications. Try to check the report in builder by commenting those srw exits

    See less
    • 0
  5. Asked: April 8, 2017In:

    How to show a message in a report at runtime?

    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    hi Albert, You can display a message in Oracle report builder by using the standard built-in srw.message. The basic syntax for using this package is: srw.message(error_no,'YOUR MESSAGE'); the error no will appear along with the message text. and here is the sample to do this in a particular functionRead more

    hi Albert,

    You can display a message in Oracle report builder by using the standard built-in srw.message.

    The basic syntax for using this package is:

    srw.message(error_no,'YOUR MESSAGE');

    the error no will appear along with the message text. and here is the sample to do this in a particular function

    FUNCTION chck_sal RETURN BOOLEAN IS
BEGIN
  IF :sal < 0 THEN SRW.MESSAGE(
    100,
    'There is employee that take negative salary.'
  );
RAISE SRW.PROGRAM_ABORT;
ELSE :bonus := :sal * .01;
END IF;
RETURN(TRUE);
END;
    See less
    • 1
  6. Asked: July 11, 2016In:

    How to pass date parameter to oracle report builder ?

    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

    hello albert,  your code is correct can you write what is the error exactly to help you. in addition you can check your user parameter  in your report builder property specifically these properties mentioned in below image

    hello albert,
     your code is correct can you write what is the error exactly to help you.
    in addition you can check your user parameter  in your report builder property specifically these properties mentioned in below image
    pass date parameter to report builder

    See less
    • 0