Clob data from database table to insert images in report

Clob data from database table to insert images in report

Posted by: sunilkumarsk20198 on 7 October 2022, 1:01 am EST

• 

  sunilkumarsk20198

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 October 2022, 1:01 am EST

  I have gone through the documentation. I found that if a database table field contains base64 encoded image, then it can render the image in report but I have clob data type field in database table which stores base64 string. Is there any way to use clob data type field value to insert images in report dynamically?

• 

  sergey.abakumov

  

  • Post Options:
  • Link
    Copy

  Posted 9 October 2022, 7:24 pm EST

  Hello,
  
  Do you use ActiveReports.NET or ActiveReportsJS?

• 

  sunilkumarsk20198

  • Post Options:
  • Link
    Copy

  Posted 9 October 2022, 8:29 pm EST

  ActiveReportsJS

• 

  sergey.abakumov

  

  • Post Options:
  • Link
    Copy

  Posted 9 October 2022, 8:37 pm EST

  Hello,
  
  ActiveReportsJS can’t be connected directly to a database, it supports the JSON format only. Json format does not have “clob” data type, it can only contain strings. An Image report item can be bound to 64-base strings contained in a JSON file.

• 

  sunilkumarsk20198

  • Post Options:
  • Link
    Copy

  Posted 12 October 2022, 4:09 am EST

  Thanks Sergey, it helped me in solving my issue.