Dataset display error

Support
#1

Hi all,
I am trying to create a reports for clinic system, the report displays patient(master) data and his visits(details), each in a separate band, patient band displays its data correctly, but visits band displays just first visit and discards remaining visits.

I have followed the documentation tutorial typically.

Any idea by anyone will be appreciated.

Thanks

#3

Hello,

Please send an example of the report that it produces.

Regards,
Nikita

#4

Thank you @shchienko for your reply.

I am using following template:

template

and details/visits query returns 3 rows, so I am expecting three rows under “Sessions” section, but I get the following result:

result

Following the report structure:

report_01

report_02

#5

Have you tried directly querying your database for sessions? How many records are returned in this case?

Regards,
Nikita

#6

In case of using direct query for sessions and a single band “session” directly under “Root”, it returns the correct count of rows

#7

Unfortunately, at the moment the “Reports” addon does not support nested bands in the form of nested tables.

I created the ticket - Ability to use band hierarchy with the docx-template · Issue #2422 · jmix-framework/jmix · GitHub

Workaround: you can try to create HTML template and set output type PDF to the HTML template. It should work.

Regards,
Nikita

#9

Or use XLSX template - it supports unlimited nesting of bands.