Forum Stats

  • 3,853,561 Users
  • 2,264,238 Discussions
  • 7,905,390 Comments

Discussions

How to Display image on 11g report from a network folder

user1538329
user1538329 Member Posts: 2 Blue Ribbon

Dear All

I want to display a picture in the oracle 11g report depending upon a variable i.e. EMP_CODE with a static network folder path i.e. \\10.1.1.81\emp_images\

I made a field on the report to display the employee image

and I set its property READ FROM FILE = YES and FILE FORMAT=IMAGE

But the following error occurs

"File '\\10.1.1.81\emp_images\111.JPG' not found. "

The path is correct because if I run the report in report builder, it shows the picture but when I call it from a form (deployed on WebLogic 10.3) it gives the above-mentioned error.

My platform is:

Oracle application server 10.3 (11g Forms & Reports) installed on windows server 2016

and oracle report builder 11g installed on widows 10 for development

Comments

  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member, Moderator Posts: 331 Employee

    Map the network drive as a local shared drive and use the same path for reading the image

    -localname:"Z:" -remotename:"\\HOSTNAME\rep_cache" -remoteuser:"USERNAME" -remotepassword:"PASSWORD"

     Z: has been mapped to a shared network drive.

    Example

    z:\emp_images\111.JPG