Fixed a potential bug to do with the making of the test units table. Updated all the .rcf files, so they will work with the newer versions and take advantage...
Hopefully fixed a strange, rare bug, to do with the making of the BP tables. As far as I know only showed with one user. It meant that the 246.. BP entries...
Finally fixed the bug I mentioned in the previous post. As far as I know this occured with only one user, but it was a serious bug as it meant BP searches...
Fixed a bug to do with showing the birth month in place of the date of birth. Putting both the DOB and the BM in the ID node output would mean a lot of...
Due to a minor issue 13.91 wouldn't work on Excel 2000 or maybe even 2002. Luckily I was alerted to this by Ian Lewis. Thanks again, it saved a lot of hassle!...
Bart Thanks for your message on the s6000 user list. I am just getting used to the Thunderbird e-mail client at home and haven't yet worked out how to alter...
Hi Bart
We have been asked to report on Childhood Imms so that the Child Health
records can be kept up to date.
I have produced the attached report but am...
Hi Les, Figured it out after Steve Speakman told me in what table this was. This is how you do it: Take you existing report. On all your morbidity nodes stick...
No trouble. Did it work OK? Was it slow indeed? Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of...
Fixed a rare bug that would show after inserting nodes (insert child) at the very top of the tree, copying that whole brach and then pasting that branch. Can...
Hi Bart The report ran fine. I only added the SQL node to the first morbidity node to start with. Unfortunately this didn't pick up any batch nos. Further...
Quite a few minor fixes and additions. Making/adding to BP tables a bit faster. Some minor improvements to the drug queries. 2 extra sheet routines, copying...
Bart Is it possible to report on the date of last registration change (last update on registration view) I just need a column in the spreadsheet. Paul...
Paul, Try this SQL: SELECT P2.PATIENT_ID, P2.REGISTRATION_START_DATE, P2.UPDATED_DATE FROM PATIENT P2 WHERE P2.UPDATED_DATE > 0 Put this in a SQL node and tick...
As requested: Added a button to the file search utility (Options, File, Find files etc.) to open the report that has the file path in column A of the sheet. So...
Bart As well as Rep-Aid we also have contract+ which gives us our register for various areas e.g. CHD. Using the Excel output, we can thus produce a list of...
Andy, You sure can, but I am not sure if there is much benefit in importing lists in this situation. If you do want to import lists then do this: ID node, with...
Forgot to say: tick the FLN checkbox in the report node, to show only the patients that appear in the very last node of that report. It will save you using the...
Added 2 quick data dumps for the patient loaded in Synergy/S6000. So, now there are: Current medication (as per the Synergy definition) Vaccinations BP's Most...
Some minor changes to make the software ready for Excel 2007. Have downloaded and installed the beta-version of this and all working fine. As I am waiting for...
This is now ready for general release. Only difference with 14.02 is that there is another quick data dump of the patient loaded in Synergy/S6000 that does all...
Fixed a bug that would show if you did all 5 quick data dumps and no patient was loaded in Synergy/S6000. Added the option to make the dropped down Excel name...
Could any 'Rep-Aid' expert tell me if this one is possible! One of our GPs would like to know how many over 60s and 'medically-exempt' patients receive more...
Val, This is one way of doing it: ID node with minimum age 60 SQL node In the SQL box paste this: SELECT E.PATIENT_ID, AU.LAST_ISSUED_DATE FROM ENTRY E INNER...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
