This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

reports 11gr2 - rwservlet.pdf how to change filename generated by reports server

iTech Solutions
iTech Solutions Member Posts: 58 Blue Ribbon
edited Dec 3, 2018 3:28AM in Reports

Hi,

i am looking if its possible to change the pdf file name generated by reports servlet . i tried setting desname option

using destype=cache, desformat=pdf

if custom name can't be set, then is it possible, that it atleast generate output pdf by the filename of report.rdf / report.rep

Oracle Reports 11gr2 64-bit

Windows Server 2012 64-bit

Weblogic 10.3.6

kindly advise.

Tagged:
iTech Solutions

Answers

  • Dan Andro-Oracle
    Dan Andro-Oracle Posts: 762 Employee
    edited Nov 28, 2018 10:06AM

    Hi,

    You can try with destype=file desformat=pdf desname=location/filename.pdf

    Regards,

    Dan

  • iTech Solutions
    iTech Solutions Member Posts: 58 Blue Ribbon
    edited Nov 29, 2018 5:07AM

    This will save file on the Application server then. isnt it ?

    app server that is sending report back to client browser, with pdf format, can we change name of that file.

    client end is simply opening a report on browser and report is displayed at end user pc.

  • Matej D.
    Matej D. CroatiaMember Posts: 1,044 Gold Trophy
    edited Nov 29, 2018 9:25AM

    As Dan write you, generate a report to a file system with a name you like and use OHS to map requests to files.

    For example:

    1) create a local folder on the application server

    2) generate a report in that folder with the desired name (myname.pdf)

    3) modify OHS to forward requests for myname.pdf

    Regards

    iTech Solutions
  • iTech Solutions
    iTech Solutions Member Posts: 58 Blue Ribbon
    edited Dec 1, 2018 6:56AM

    since the job will run at server independently, how the OHS will be callback when the report will be saved to app server folder ?

  • Matej D.
    Matej D. CroatiaMember Posts: 1,044 Gold Trophy
    edited Dec 3, 2018 3:28AM

    Here is how I did this on Linux.

    1) httpd.conf

         AliasMatch ^/fileprint/(.*)?$ "/app/fileprint/$1"

         <Directory "/app/fileprint">

               AllowOverride None

               Order allow, deny

               Allow from all

         </Directory>

    Reports with the desired name are generated in folder /app/fileprint.

    2) In forms when running report:

         SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESNAME,'/app/fileprint/'||myfilename.pdf);

    3) When the report is done:

         web.show_document('/fileprint/'||myfilename.pdf,'_blank');

    Regards

    iTech SolutionsiTech Solutions