I am trying to use a custom excel file to run OpenMRS report, it is running correctly in Web Preview , but in the Excel Sheet it is just displaying field names.
Any help will be appreciated.
@satyadoorva - at first glance at the screenshots you provided, it appears as though you have not configured the repeating sections property that needs to be specified. This is what tells the renderer to “repeat” row #8 in your template with each row in your ListOfPatients dataset.
See: Render a Report Into a Custom Excel File - Documentation - OpenMRS Wiki
Hi @mseaton ,
Thanks for the reply.
I configured repeating sections as per this URL
However the data is still not reflecting.
Can you please advise.
@satyadoorva try to change dataset name in your Excel custom template from “ListOfPatients” to ‘ListofPatients’ as it is the right key seen here in your dataset mapping
@dbaluku changed https://i.stack.imgur.com/BaDN2.png but no change in output as per https://i.stack.imgur.com/qwKHD.png
@satyadoorva you don’t have to define the columns "1-5 " on the repeating Section section .Leave the Column field blank
@dbaluku thanks a ton this helped a lot!!!