Notifications
Clear all
Topic starter
When I specify the range to show patients with a certian obs lab value through the selection expert it doesn't list the patients in the correct lab value range? Howcome? Such as show patients whose triglyceride is greater than 200.
Posted : November 6, 2012 6:22 am
Can you take a snipet/screenshot of your specific selection criteria (or copy/paste) and post it? Also, if you remove your selection criteria, does your report populate with values that you eventually want to narrow results to (e.g. show Trig values of greater than and less than 200)?
Posted : November 6, 2012 7:04 pm
Topic starter
Sam said:
Can you take a snipet/screenshot of your specific selection criteria (or copy/paste) and post it? Also, if you remove your selection criteria, does your report populate with values that you eventually want to narrow results to (e.g. show Trig values of greater than and less than 200)?
Selection Criteria Formula:
{OBSHEAD.NAME} = "TRIGLYCERIDE" and
{PERSON.PSTATUS} = "A" and
{OBS.OBSVALUE} > "200"
The report above is supposed to be showing the criteria, but notice that its showing patients with less than 200 TRIG value as well? When I remove the OBS.OBSVALUE > 200 criteria, it shows all patients regardless of what the TRIG value is.
Posted : November 6, 2012 10:28 pm
And you've refreshed your report after verifying the selection criteria? I do not see anything off right off with how you have your report built.
Posted : November 6, 2012 10:43 pm
Topic starter
Sam said:
And you've refreshed your report after verifying the selection criteria? I do not see anything off right off with how you have your report built.
Yes Ive hit refresh and the screenshot of the report was the data that was returned after I hit refresh. So when you run the report on your end its showing the right data & you dont see any pts listed that have less than 200?
Posted : November 6, 2012 10:57 pm
Post the .rpt file (without patient data saved to report) and I'll check it out.
Posted : November 6, 2012 10:59 pm
Topic starter
How can I do that without saving the data to the report? Once I put the table.fields in the report, it pulls the data??? I am not sure what you mean by sending rpt without data saved to the report?
Posted : November 6, 2012 11:08 pm
When you click on the File menu, there is a Save Data with Report option. Make sure it's unchecked. Then you just save the .rpt file and upload it here.
Posted : November 6, 2012 11:18 pm
Topic starter
How can I upload the file to here? It will only let me upload images or media? I dont see a button on the toolbar for files?
Posted : November 6, 2012 11:30 pm
Search the forum for help on that issue--there are numerous threads that cover this better than I could.
Posted : November 6, 2012 11:32 pm
Topic starter
Do you mind giving me your email? I could email you the rpt instead?
Posted : November 6, 2012 11:39 pm
wsc27 said:
Do you mind giving me your email? I could email you the rpt instead?
I received your report and after playing with it for a while was only able to get it to perform as expected by using the below formula. I'm unsure why this obs term acts in this way--other obs terms I tested performed correctly using the "is greater than" option.
This formula displays values from 200-1999, if you want to capture values beyond 1999, you'll have to add the additional segments (e.g. 2???, 3???, etc).
-Sam
Posted : November 7, 2012 1:31 am
ToNumber({OBS.OBSVALUE}) > 200
Posted : November 7, 2012 11:41 pm
Topic starter
I am still getting formula errors for the part that you suggested for the OBS Value range. Ex. ToNumber({OBS.OBSVALUE}) > 200
Here is what I have in my formula so far:
The first section works til I add in the ToNumber section....
{PERSON.ISPATIENT} = "Y" and
{PROBLEM.CODE} = "ICD-250.0" and
{OBSHEAD.NAME} = "HGBA1C" and
{OBS.OBSDATE} in DateTime (2011, 01, 01, 0, 0, 0) to DateTime (2012, 11, 12, 0, 0, 0)
({OBS.OBSVALUE}) > 200
Posted : November 12, 2012 1:07 am
Page 1 / 2
Next
