Quite a few additions and fixes. Added the option to fill referral templates. This is how it works: It is all very similar to doing a mail merge in Rep-Aid,...
Hi Bart Sorry if this has been asked before. Can Rep Aid count entries rather than just patients? I've been asked to count the number of Cat A Minor Surgery...
Hi Les, Yes, you can do that in 3 ways at least. 1. Have only one morbidity node holding all the Read codes and with the A option picked. This will add up at...
Hi Bart Thanks very much. I like the Op_Count solution. How do I change the column selected by the macro? As for registration - Sometimes I am asked to count...
Hi Les, Alter the column with the macro editor. This is a relative new feature and you can get there via the show button or via the macro wizard. Will put your...
I need to produce a report to show our Surgeries Formulary list. How can I identify the Formulary list so as to produce a report ? Also the PM wants to know...
Have come across a situation where the file GetLicense.exe wouldn't get the right data to make a licence due to a missing entry in the Rep-Aid .ini file. This...
Hi Steve, Had a look at this and it looks fairly simple. There are 2 tables that deal with this: FORMULARY, listing all the formularies FORMULARY_READCODE,...
Steve, This SQL for example will list all the drugs in our Extended Nurse Prescribing formulary: SELECT R.READ_CODE, R.TERM30 FROM READCODE R INNER JOIN...
Or this one,which gives some other details: SELECT R.READ_CODE, R.TERM30, R.USAGE_COUNT FROM READCODE R INNER JOIN FORMULARY_READCODE FR ON (R.READ_CODE =...
John, You/somebody must have turned it off. Put it back like this: Options, File, Checking version, Set if version check at Excel startup, Yes. On 13.69 now. ...
Paul, Will put in 13.70, which I will upload today. You can actually do this already quite simply: ID node with any registration. Stick on that ID node with...
Paul, Couldn't upload to the main site, but have uploaded 13.70 to: http://www.rbs-software.pwp.blueyonder.co.uk/ This has Any but adopted child. Bart ... ...
Maybe I did it. Bart ... From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of John Farrell Sent: 10 May 2006...
Fixed a bug where newer BP tables or a TestUnit table weren't copied from the server to the local PC. No harm, but it meant one would waste time updating these...
Bart, For a pilot project I need to be able to dump to excel a list of all Read Code entries (non-dug) between certain dates, rather than the usual one line...
Some interface fixes and improvement, partly due to seeing John Lockley struggling with a few things: 1. Template button won't show with the single patient...
Paul, No trouble, just tell me the dates and I will send you the SQL. Then paste this SQL in the SQL node big box, right-click and do: Run plain SQL. Just to...
Cheers Bart, I need last 2 years data 1/5/04 to 30/4/06 - though I may split that down 'cause I'm not sure how many lines Excel can cope with at a time. The...
OK, this is actually faster with a normal report (not a plain SQL) with a SQL node. This is because otherwise you will need a big join between the Tables...
Paul, 2 more things about this: Firstly, with this query there would be an error message about NULL values. It would still produce a good result, but I have...
Thanks Bart. All the entries are visible in the temporary txt file. How do I add computer number rather than internal PID, and age & sex to output? Paul. ... ...
Paul, That won't be easy as that query (the one in the SQL node) has no join to the table PATIENT. This was just what I was avoiding as it will make things...
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.
