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 - ...

• Signature Capture Issue in Axpert Mobile v10.9

  The issue is with the signature capture functionality in the latest version of Axpert Mobile (v10.9). There is no default feature to draw signatures on the input field. If it is referred to saving through an image field and using it on fast report, ...

• 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>'