Using images in tabular format in report

Support
#1

Generate report based on an Entity and Entities in tabular form.

When I generate a report with Order containing one Line i get the image in Tabular line.
When I generate a report with Order containing two or more Lines i get no image at all only the tag in Tabular line.

One Line in Order
Example 2

With Multible lines
Example 1

Does someone have an idea of how to solve this?

#3

Hi.
Could you please clarify which platform version do you use, which type of template do you use (Xlsx, Word, etc.) and what field format for the field which contain image do you set in the report setting?

Regards,
Natalia

#5 
 CUBA Platform version: 7.2.11
 CUBA Studio plugin version: 15.2-202
 IntelliJ version: CUBA Studio 2020.2

I have used Docx as Template.
i have used ${imageFieldId:50x50} on each line.
The lines is an own ReportBand RiserLines and image is an FileDescription reference.

#9

Hi.
This issue can be solved like this:

  1. Create typical report for single entity with tabulated region. In region choose field with ‘yourFile.id’. This step needs to make a default template which will be used later.

  2. In editing report window select band with list of entities and change dataset type ‘list of entities’ to ‘JPQL’ like this:
    image
    In this example name of band will be ‘NameBand’.

  3. Create a JPQL-query from table (‘Lines’ in your example) with fields which you need in report like this:
    image
    Field ‘${parameter_order}’ will be set from entity which you’ll choose for your report.
    Alias for column ‘yourFile.id’ will be used in next steps, in this example it’s ‘image’.

  4. Add new value format for field ‘NameBand.image’ like this
    image

  5. Download template here:
    image

change field ‘${yourFile.id}’ to ‘${image}’, save and upload this template to report.
6. Save a report
7. Run

Such a result for example:
image

Regards,
Nadezhda

2 Likes