XML Publisher - How to print images stored in BD

Oracle Business Intelligence, Oracle Warehouse Builder OWB, Oracle Discoverer, BI Publisher, XML Publisher, OLAP, Data Mining, ODI Oracle Data Integrator, etc
Post Reply
User avatar
Daniel_Azevedo
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 19
Joined: Thu, 12 Nov 2009 1:19 pm
Location: Caxias do Sul - RS
Daniel Azevedo
Analista de Sistemas
Oracle EBS
Oracle Apex
Forms, Reports, PL/SQL, Designer

I am having to attach to my report created for the XML Publisher a stored image as JPG in a BLOB field of the database and display it in the document body to be printed with the report.

Has anyone ever developed something similar or do you know how to do it?

Thank you for help.

ABS

Daniel Azevedo
dfalcao
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Fri, 24 Sep 2010 10:15 am
Location: Gravatai - RS
DFalcao - Douglas Falcão Lopes de Oliveira

DW, BI, ETL Specialist
--------------------------------
OCP Application Developer
SCJA 5
--------------------------------

Daniel.

Did you map this BLOB column in the semantic layer in the repository?

This is the first step for you to have facility in using this data in the Answers and Publisher tools.


User avatar
Daniel_Azevedo
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 19
Joined: Thu, 12 Nov 2009 1:19 pm
Location: Caxias do Sul - RS
Daniel Azevedo
Analista de Sistemas
Oracle EBS
Oracle Apex
Forms, Reports, PL/SQL, Designer

Hello Dfalcao, could you give me more details of how to do this? I'm not too much inside the subject ....
carlynhos77
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 172
Joined: Mon, 24 Oct 2016 7:20 pm

daniel_azevedo wrote: Hello Dfalcao, could you give me more details on how to do this? I am not much inside the subject ....
Hello, good night

You have been able to solve this image problem in BD and pass via XML for an RTF template via Publisher ?? appreciate
dfalcao
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Fri, 24 Sep 2010 10:15 am
Location: Gravatai - RS
DFalcao - Douglas Falcão Lopes de Oliveira

DW, BI, ETL Specialist
--------------------------------
OCP Application Developer
SCJA 5
--------------------------------

Carlynhos.

The tip I have given to Daniel for 8 years, was to map the BLOB column into the BI repository, the RPD file on the semantic layer. If you are mapped as BLOB or Other Large Object in the RPD File, you can use this data in both the Dashboard and Publisher tool.

grateful
Dfalcao
carlynhos77
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 172
Joined: Mon, 24 Oct 2016 7:20 pm

It's, in the case here, I have the image saved from the database, Annex she ... I tried every way, but it does not appear in the RTF, the registration data is displayed normal, just the image that does not appear
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 4 guests