Hi Bart ID nodes with SRS 'ticked' are just displaying 0 (zero) in each status cell. Don't know when this started as I don't tend to use that option very ...
Have uploaded a new installer with all .rcf files fixed to work with having no ADO in the .xla. This is the same version, so 19.33 but a new folder ...
Speeded up all searches a lot by altering the code that writes data to SQLite. This can make reports up to twice as fast, so worth installing this update. ...
This version won't work with the existing .rcf files as a variable has been renamed in the main add-in file. This was a variable for the ADO connection and...
Hello Trying to make report to use with patient in the consultation. To show all scipts issued in say last year... every script. arranged alphabetical But...
I used this report. I typed my patient's ID number into top left cell in excel sheet and put another ID number in cell below that. but was OEN not PID. so gave...
Hi George, It runs fine here. Put PID in cell A1 and PATIENT_ID number in cell A2. Then select both cells and import. This always needs to be a PATIENT_ID...
Thanks for that Not quite what I am needing. How do I find out what patient's PID is in Synergy e.g patient is in consultation with me and I want to do RepAid...
OK, what you do is this: Load patient in Synergy Load report in Rep-Aid Select the ID node Import List, Synergy Then run it the normal way That should do what...
George, Looking at the colour of Rep-Aid you made it a single patient report, but you want a normal report. Just follow the instructions as below. Bart _____ ...
Like magic it works!!!!!!!!!!! Thanks for that. I hope this will help in doing medication reviews on the difficult patients with lots of medications? I am off...
Bart I would like to create a report that produces a list of patients that have a dormant problem that has no attached notes or drugs. I would like to specify...
Hi Paul, Yes, that can be done. There could be a simpler way, but I would do it like this: Setup your ID node as required, if needed add more nodes to specify...
This is quite a major update. The 2 main things are: 1. The ReadcodeBrowser.xla is gone and all this has been moved to main .xla file SynergyReporting.xla and...
Hi Paul, I replied a bit quick to this yesterday and you can speed this up a lot by only getting the problems with no linked entries by adding to the SQL: and...
Bart I would like to add other Read Codes than those in the default WordEntries.csv file It is not all that clear how to do this from the installation help...
Hi David, Simplest is to open that .csv file in Excel and insert a row at the right place and copy another, similar row (same SQL, but different codes) and...
Better handling of reports on GPP tables as dates and users are now converted. These tables have DDMMYYYY dates and before they were converted as if they were...
Had a request if it were possible to do Read code to Yes for individual nodes and not all nodes. This is possible with a macro, but that is a bit cumbersome,...
... Make that top left. Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of bartsmissaert Sent: 13...
About this new option: update sqlite_tablePa set read_code = 'Yes' This only works on nodes that don't have the A option (show all entries) ticked. Will see if...
This will make the option to have a SQL node that does an UPDATE or DELETE on SQLite tables also work on SQLite tables produced by nodes with the A option...
Some minor fixes, one to do with a scheduled making of the BP tables. Note that with the new SQLite method these tables are not used anymore. Version 19.41 ...
Bart Thanks for your help with this - the ECG entries now work I tried to use the HbA1c entry - this return no entry even when it is present - I have tried...
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.
