Had a few requests for this and have now added the option to add comments to the report file, this is the actual text file. This is so that when you move your...
Hi Bart I run a report each month to list all vaccs issued Last Month - this is so I claim all vaccs given. Under Registration types I use "any but Private or...
Hi Les, You can do this quite simply, but I need some details about the registration of those patients. Could you run this plain SQL: select patient_id, ...
Hi Les, OK, in the ID node in the regular registration box put Non GMS Now at the bottom in the first XTR box get QUALIFIER_REG_TYPE And in the box after that...
Hi Les, OK, I see now. Try the attached report. Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of...
Hi Bart
That certainly seems to exclude the appropriate patients. However it does
seem to list all 35112 patients in the detailed results!
I've attached my...
Les, Do it like this: Setup your vaccination report, but don't yet deal with your travel reg patients. Then on the very last node of the report stick your ID...
Les, The other report you sent has to be done a bit differently as there is no single final node and see the attached report for this. Hopefully now you will...
Fixed one minor issue to do with the new feature to add Comments to the report text files and have uploaded a new version to both sides. Again, this is...
I have done Bart and the numbers seem to tie up - I meant I'll see again next month when I run the reports for all of Sept. Whilst it's fresh in my mind, I...
Fixed a problem in the SQLite method that would show if you ran a search with the all option (show all entries) and had done Options, Excel output, Set if...
2 bug fixes and one addition. Due to some typo kind of bug the test node first Read code box would not update. In SQLite method with SQL node with both...
Some minor fixes and extended the information that will be added to the file properties when you opted for this with: Options, File, Set to set report file...
Fixed a bug to do with the Previous quarter button in the relative date (RD) dialog. Noticed that you get the current quarter not the previous quarter. This...
Not a bug fix as such, but something I thought could be handled better. This has to do with the Start after and Start before boxes in the Morbidity and Test...
This new feature, which will make a file popup in explorer with information about the report won't work on win 98 and win 2000. So on those machines just leave...
Hi Bart
I'm unsure why I am getting an error message on this report? Version 1
worked initially, Version 2 doesn't. I've played around with it in several...
Hi Richard, ... Definitely not, any error like this (where you land in the VB editor) is a bug of the software and I will see if I can fix this today. Bart...
Richard, Had a look at your report and have altered a few things and it should run fine with the new SQLite method. This is better in these reports in any case...
Richard, As to the error you reported: This is indeed a bug, but it was due to the dot in the report name or in the text of the report node. The software...
Thanks Bart, the shorter report (without surgery or letters) now works but still the same errors on the others, seems to be when the collection node starts. ...
Yes working now, I certainly couldn't have worked that one out by myself!! My earlier reply was without seeing your later email. Many thanks RIchard On...
Fixed the bug to do with the report file name or the text of the report node starting with numeric(s), followed by dot(s). This had to with the fact that at...