Bart or anyone What I would like to do is find out the date when patients were first started on a particular drug that they are still currently having. A...
David, That is an interesting one. I think what will do it is this: A drug node with in the top drop down box: Issue Tick C Auth and tick the F (for show first...
David, Had a better look at this now and this is how to do it. Say you are looking at beta-blockers, bd First drug node, put in Current medication, bd in Read...
1. Some speeding up of a few SQLite routines. 2. Added the option to the SQL node query box to count strings and replace strings. This is in the right-click...
One feature I hadn't mentioned (as it wasn't added yet when I uploaded) is this: When you run a report with a large number of nodes there might be quite a few...
Hi Bart
I'm running Ver 16.48 and I've attached a regular monthly report.
I am now getting this message – any ideas?
"Cannot complete SQL Statement: table...
Hello Bart Today staff changed to using your Dump ID into excel instead of writing in the book, scripts to go to GP for re authorising and also telling them...
Hi Les, Ah, running the new SQLite method, very good! This has to do with a change of the layout of this SQLite table and this will solve it: Right-click any...
George, ... I think the solution for this is simple to do a freeze pane in a row below the button. Put the button at the very top and then click in the row...
Fixed a problem (thanks to Kate Lamb) that doesn't have to do with Rep-Aid but with the default behaviour of Excel and that is that newly inserted sheets will...
Bart I cannot get Rep-aid to run on other machines. We now have now paid for a practice licence. Error message appears saying no licence. The license.txt (US...
David, To activate the licence on other machines you have to do this: Run (double-click) the file: C:\RBSSynergyReporting\Program\GetLicense.exe Make sure to...
Bart the missing referral letter report (came with the program) errors The second field SELECT needs to be an entry id when showing all entries ...... cannot...
David, It sounds you are running this with the SQLite method. Do this: Options, Debugging, Turn SQLite method on/off, turn it off. Then run the same report the...
Had left a comma out, so it should be: SELECT E.PATIENT_ID, E.ENTRY_ID, E.ADDED_DATE, Etc. Just alter and save the report, overwriting the old report. Bart ...
Added the option to setting the sheet print parameters (Options, Excel output, Retain current sheet printing parameters) to turning this off. Setting the print...
Fixed a bug (actually normal Excel behaviour) where pressing the Escape key when RA had launched a folder or file browse dialog would halt the code and get you...
HI Bart Just a quicky - is there an easy/quick way to 'block' change all the dates in a specific field in all nodes of a report to the same value. e.g. date...
Yes, there is. Right-click on a node that has the right date and do Copy treeview dates down. There are 2 ways to do this: only paste to nodes of the same type...
Thanks for your usual prompt & helpful response! After a subsequent look, I have now found it in the help under 'advanced features'. I was just looking under...
Bart Is it possible to create a list of the first current problem by the "applies from" date i.e. at the top of the current problems list? A morbidity node ...
Paul, The problem is that many problem entries have no START_DATE (applies from), so when this is the case the ADDED_DATE (entered date) is taken instead. I...
Mainly some fixes to do with the SQL node in the SQLite method. The SQLite coding was based on the assumption that the PATIENT_ID's are always in a field...
New to Rep-Aid, new to this group, so be gentle with me.. Has anyone created a report for submitting target claims for childhood imms to the PCT? Synergy's...
Bart Thanks. I think you've identified the problem i.e. the "entered date" is being picked up rather than the "applies from" date. The problems I am interested...
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.
