Birt : How I can generate attachments that are stored in Postgres table

Question

How Can I create Birt report that will have links to files that can be downloaded by user.

For ex : I have Postgres table that contains following files data(file content stored as bytea)

---

filename mimetype filecontent(bytea)

file.pdf apple/octet-stream

It contains all the file types(doc, csv, xls jpeg, png etc)

I need to create report that shows all the attachment details and also link to download them.

Answer 1

Creating a link is easy by using the dynamic text item with content type HTML and constructing an element inside.