hello all
i just installed openemr for a clinic that performs gastro-intestinial procedures on patients . and i had to create seperate forms for oesaphagus , stomach and duodenum etc to make the report clearer when printed .
but now i would want to export the data to a spreed sheet for analysis and would like to have it in one sheet being that the different forms are on different tables is there a way i can get patient encounter and all the forms that were entered to a different table on the basis of (a patient encounter - entries of all forms entered ) per role
The existing reports, as rudimentary as they are, pull up all forms for an encounter.
If you’re trying to get the data into a spreadsheet form instead of just an on-screen display then you might consider creating a new reporting PHP file. Create a CSV (comma separated values) file in the PHP and then send it out as a web page. You can change the HTTP header too so that the browser sees the contents as a CSV and prompts you to open or save the file.