HI,
I want to add a list in a DOCX template for generating a report.
Suppose i have a list of person_name. I want all to be appear in my report.
The query i have written is giving list of person_name. Only want to know how to place it in the DOCX template. So that all the name will publish in the report.
Hi Rostislav ,
I have tried to get the list of data in my report. but its not working. getting only the first row data. Below is what i have done
This is the query i have written for getting records.
select x.first_name as rel_f_name,
x.middle_name as rel_m_name,
x.last_name as rel_l_name
from demo_sem1.sem_person x
where x.id in
(select rel_person_i_d_id from demo_sem1.sem_case_header a
inner join demo_sem1.sem_person b on a.person_id = b.id
inner join demo_sem1.sem_personrelationship c on a.person_id = c.person_i_d_id
where a.id = "9d7c5fb4e0972751901098682dd1b4c2")
This query is returning the following values from MySql database :
rel_f_name | rel_m_name | rel_l_name
Hari | charan | das
Raghu | charan | das
And this is what i have mentioned in my DOCX template :
Hi Rostislav ,
I have tried to get the list of data in my report. but its not working. getting only the first row data. Below is what i have done
This is the query i have written for getting records.
select x.first_name as rel_f_name,
x.middle_name as rel_m_name,
x.last_name as rel_l_name
from demo_sem1.sem_person x
where x.id in
(select rel_person_i_d_id from demo_sem1.sem_case_header a
inner join demo_sem1.sem_person b on a.person_id = b.id
inner join demo_sem1.sem_personrelationship c on a.person_id = c.person_i_d_id
where a.id = "9d7c5fb4e0972751901098682dd1b4c2")
This query is returning the following values from MySql database :
rel_f_name | rel_m_name | rel_l_name
Hari | charan | das
Raghu | charan | das
And this is what i have mentioned in my DOCX template :
In your report you use a single band for all the information. That is the problem. A table for list of entities must have separate band.
In your report create a separate band for list of relatives, and everything should work correctly.
For more information about Report data structure see the documentation.