Page 1 of 1
exporting reports
Posted: Sun Jan 12, 2020 7:46 pm
by drmiller34
I have medisoft v20 basic and have created address labels but cannot export them as an .xls file. They are saving only as .QRP files. How do I convert them for editing and printing via excel?
Re: exporting reports
Posted: Mon Jan 13, 2020 9:24 am
by Gavin Walker
It is kind of complicated with the Basic edition as you can't do a print grid to export out the entire patient table. There is an ODBC driver on the Medisoft v20 disk that will allow you to connect something like Microsoft Access to export your data to an Excel file. Another way to do this would be to design a report in Medisoft Report Designer that only contains detail lines and the fields you want separated by commas. There will be extra blank lines for the header and footer so you will have to manually delete out the blank lines.
Re: exporting reports
Posted: Sun Feb 09, 2020 12:17 pm
by Hearmel
I have Medisoft V20 professional. I need to generate an Excel file for my board re-certification. This requires a 6-month list of all patient contacts. I have reviewed your youtube video on this from 2014 (thank you), but i do not see any "transaction export" file to do this. Thanks.
Re: exporting reports
Posted: Mon Feb 10, 2020 9:51 am
by Gavin Walker
Hi, if you have a minute, be sure to thumb up our videos.
In Medisoft go to Reports > Medisoft Reports > Focus On Data > Export Transactions Data. Follow the instructions on the first page of the report that comes up. That should give you an extract of the Transactions Table.