Home Forums Discussions Problems Using the REPORTS button

Hi all
I seem to have problems using the reports button correctly.
I want to look up the number of flu shots given in a particular month. I put in the starting date >=, then the ending date <=, then put in the code.
What I get back is any patients who were seen in that month and who also had that code ANYTIME, not just in that month.
??
Julia

I put my reply in the wrong thread. Another reason for the PM. Please look there. I did post your question.

Julia,
Not sure how you are running the report, but are you using the "And" function to create it?
One query is for patients seen in particular month
AND
second query line is for those who have flu shot cpt code.

This is a problem with the AC search. It will only look to see that flu shot was given but not that the flu shot specifically was in the time frame, even though it already limited the population to those seen in the last month. I have had this problem with other searches and do not have a solution.

yea, thats how it has been done. 3 lines, tried different orders, using AND. I played and played with the differnet ways to do it for 2 hours.

YES EXACTLY
I find out that yes that pt had a flu shot, and yes they were here in november. But the flu shot was given not in that time frame. I can't get it to narrow down.
I thought this is what reports are generated for, so i know I must be doing something wrong?

You could add a separate tracked data value in the patient's chart called Flu Shot Date.

Julia,
Can you explain more precisely how you are doing this. Do you record a cpt code at the encounter when you administer the flu shot (I don't know the right code; G0008 perhaps)? Then do a two line query, one for patients seen in the month in question, and the second for those with that code?

OK, I feel like an idiot. Is there a way that when people are talking about immunizations where VIPER and AC would apply that they specify that.

Julia if you are not using VIPER, let me know so I can delete you or you can delete yourself from the VIPER PM.

Sandeep makes a good point though. I haven't looked at this thread, but there are many ways to put words or phrases or whatever in the demographics page or wherever that is easily searchable.

Bert, This is not a VIPER issue, it is a search issue.

If you search for all patients
1)that were seen in the last 30 days AND
2)that had a procedure, say, Hgb
(in either order of query)

You will get a list that included patients seen last week but had Hgb in May.

I have not found a way around this!

Julia and Wendell,
I think I am able to run these reports. I don't do flu shots, so I cannot compare directly, but here is what I do.
Let's say I want to know which patients I saw in September that had a 99214 code. (I assume you would do the same thing with the flu shot G code).
First query is:
notes and encounters....encounter date...>09/01/2012

Second query is:
notes and encounters....encounter date...<10/01/2012

Third query is:
billing and coding...only cpt used in billing... =99214.

This seems to give me an accurate report.

Nope, didn't work.

Just ran a similar report for 90723 (vaccine) and it pulled 63 charts. I looked at the first 4 charts and none of them had a 90723 during the time frame, although all were seen in the month.

As James would say, this is where SQL Reporting services comes in handy.

OK Sandeep, please elucidate.

I suspect that Reporting services would be an engine to generate reports but that is as far as I know this aspect.

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft.

AC Uses crystal reports to generate its reports. There is a competing product known as SSRS for SQL Server. This often gives you more granular control of data. Your only limitation is probably your imagination. James posted an example of generating a record set from the data.
http://amazingcharts.com/ub/ubbthreads.php/topics/47680/Re_sending_mass_emails#Post47680

That's using SQL Server Integration Services (SSIR).

For generating the report only SSRS suffice. It's not exactly practical for a solo physician though. AC's way is much easier but limited.

thanks for trying to run that report- now I know I am not crazy or missing something.
does anyone know why we are unable to do this? It seems to me that it would be something we all want to be able to do.

My guess is Ed could improve the search in VIPER so it could find all the Baltimore Orioles' players who got a hit with two strikes in the fourth inning.

I ran following report
HEALTH MAINTENANCE immun date given > 01/01/2012 AND
HEALTH MAINTENANCE immun date given < 01/30/2012 AND
HEALTH MAINTENANCE immun name = ADACEL (from drop down)

and got only 2 patients that I gave that month and not all the rest.

Thanks, Steven.

To summarize:
Works: Steven, Jon
Doesn't work: Julia, Wendell.

What version does everyone have ?

I confess that mine is a bit newer than most and maybe they fixed it.

Steven, you HIT THE JACKPOT!

Using the health maintenance as the bases vs notes and encounters as above works perfectly. I ran August (a busy month) and they were all valid. This is great

Julia, hope this works for you too!