Exporting patient data

dunmi wrote on Monday, February 02, 2009:

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