Notifications
Clear all
Topic starter
Below is a screen shot of a Meaningful Use EP Summary report. This report will be presented during our 'oh yeah prove it' presentation at the Orlando CHUG 2012.
We use this to show physicians how they are doing on each measure with an easy to read 'green check' meaning you met the measure or a red stop sign if not.
This report is generated using the USRINFO table and an excel spreadsheet with extracted MU data for each physician. The spreadsheet is linked to the physician using the NPI number.
MU Master.xls (file renamed to .txt extension to upload)
Posted : October 2, 2012 3:44 am
aimeed,
It looks awesome. Since I wasnt able to go to CHUG, could you explain the reasoning behind the excel sheet? Why not just code it in Crystal? Sorry if these are nonsense questions...
Posted : October 26, 2012 12:01 pm
Topic starter
There are two reasons.
The first was we were initially using MQIC data and the extracts from MQIC came in this format. Our administration wanted to see each EP's data by clinic and then by physician. There was not a way when we started this project (and I have not followed up on new reports built by MQIC) to see how a physician is doing across all measures at a glance. So we used the MQIC excel extracts as our data source and then built a crystal report that grouped/sorted the data the way we wanted it allowing analysis to happen at a glance.
However, a second reason is that we have found with many crystal reports that pull a lot of data, especially observation term data, it is difficult to get all the data you want and also group/sort the information the way you want the report's end product to look. So we have found that this two step approach is less frustrating/limiting in the end. One report to extract the data and do your data validation against. The second report uses that 'view' of data and creates a visually appealing report.
Ultimately, if we had a separate reporting database that we could transfer data to and report off of, that would be the ideal solution. That would also give us the ability to do trending; a request we are starting to get more frequently. Since we don't have that, this is the next best thing for us.
I hope that helps.
Posted : October 29, 2012 3:27 am
I was wondering if you could help me with your crystal report. I see that some parameters are hard coded, but there are a few sections that I am not to clear on ( not an expert in crystal). Is there any way we can speak for a few minutes for some guidance? Please email me at [email protected], if you are able to speak.
Posted : October 31, 2012 1:02 pm
aimeed,
Could SQL be used instead of .xls to create the "view"?
Posted : December 7, 2012 5:34 am
