How to concatenate image data in Postgres to use in fast report

Define your own aggregate to do binary concatenation and use it sql. 

https://stackoverflow.com/questions/10194117/append-binary-content-to-bytea-column-in-postgresql-database

eg.

CREATE AGGREGATE bytea_add(bytea)
(
    sfunc = byteacat,
    stype = bytea,
    initcond = E''
);

select bytea_add(logoimage) from emplimage where recordid=:recordid

• Related Articles

• Unable to use regional language (Tamil/Kannada) in Fastreport and not showing output

  Please try with below options Font used in Fast Report component should support TAMIL (Recommended : Arial Unicode MS / any other Tamil fonts) In AxFastLink Table , EFONT field value should be updated as 'T' for the report, which uses embedded fonts. ...

• Validate file attachments or image upload on save

  There are two variables available to have the attached or image field values in comma separated string. Axp_AttachedFiles - is a variable that will contain the list of files (header attachments) attached as comma separated string. Axp_LoadedImages - ...

• Postgres 14 version has an issue in establishing connection from Axpert

  PostgresSQL 14 uses “scram-sha-256” method for authentication by default (as per pg_hba.conf file), which is causing the connectivity issues in Axpert. Solution for the issue : The method “scram-sha-256” needs to be replaced as “trust” in pg_hba.conf ...

• Report (Iview) is not working for a specific user but for others it is working

  It may be due to custom views sometimes and delete the record in "axcustomviews" table for the user whom it is not working. eg. delete from axcustomviews where name = ‘<iviewname>’ and username = '<username>'

• Install PostgreSQL

  Refer to the attached document for details on how to setup PostgresSQL.