FORUMS >> MEL, SQL, Oracle >> reports
Has anyone be able to create a report in the EMR with date & text parameters? I am able to get the date parameters to work correctly, but not any text parameters. See screenshot file…. Any suggestions or assistance with this would be appreciated.
I need to be able to hide a charge so it does not show up on the patient ledger. Any ideas?
Sharing the attached VFE template for data entry of outreach activity. I have also included the Crystal Report I run to work with this. The report keys on either the CDC or OTH C19 lab value being ‘positive’ or ‘detected’, or the c19 Prsum Pt having any entry. The idea is to ultimately have an […]
Good Afternoon, We are experiencing the bug in the new Rx refill form that if the medication name and the instructions are yellow in the request and the request is changed to a different dose on the refill fulfillment, it will create two instances of the medication in the medication list on the patients chart. […]
I was wondering if anyone has a good system for collecting birth outcome information for total and CDS reporting?
Hello, I am looking for an Authorization documentation form and a way to be able to pull a report from the form. Does anyone have an authorization documentation form or process they are willing to share? It would be much appreciated.
I have been asked to see if we can do a report of the custom order lists. I’ve been able to just pull in the order codes but I can’t seem to find a way to pull in the Custom List name with the order choices that are on the custom list. Is this even […]
We use the basic reports with CPS 12.0. I was trying to find information regarding Analytics reporting software on GE’s portal but I did not find it. What reporting software is everyone using and what are the pro’s/con’s for that product? Is the cost for the software annually, monthly fee, etc.? Our Practice Administrator is […]
Does anyone have any suggestions where I could find some existing Health Risk Assessment templates? Or know of someone who could create some of these quickly?
When I attempt to import a report from Crystal Reports, I get the error message in CPS PM Reports: The report file you are using is not current. Please run the utility MBCReportConverter.exe to update your report file. I feel like I came across a solution in the past, but I can’t recall where or […]
Hi, I’m wondering if anyone using CPS12.0.11+ has a report like the “Expired and Uncoded Diagnosis Codes on Custom Lists” which includes reporting on ICD10 codes? GE says it’s available in 12.2 and 12.3 LA, but have not updated the report to included ICD10 codes since the switch in 2015 in 12.0.x. Thanks in advance! […]
Does anyone have a crystal report they would be willing to share where we can look up certain antibiotics that a practice has used for a period of time per provider? Our providers are asking for this to monitor what antibiotics they use the most. Thanks Peg
Is there a way to construct interactive reports? I have a few reports that I’d like to somehow make interactive, with links or buttons to go to that patient’s chart. Is this possible? If so, is there documentation or examples I could view? Thank you,
I’m looking for a report that will list the names of patients seen who had been referred by a specific physician within a specific period of time. This would give the option to run the report for any/or specific appointment types. I cannot use the New Patient Analysis report because this is a billing driven […]
hi all, wondering if anyone has a report they can email me to get list of top meds prescribed by MD? i’m trying to help create some custom lists and this would help so much!!!
Ok report and schedule Guru’s, I need help. I am looking for a report to show any patients who still need to be rescheduled. When a provider blocks out schedule the appointment are shifted to overbooks with hash marks through them. I want to be able to run a report and show only these patients […]
I have been tasked with extracting immunization data from Centricity EMR. We want data for patients that have had specific immunizations and those who do not, so we can do outreach to those patients. I understand from co-workers that this was easier when Obs Terms were assigned to the immunizations. But now Immunizations are in […]
Hi all, I hope you are doing good. I just thought of sharing this new article with you. It’s about medical billing reports practices must use. 10 Medical billing reports that will make medical practices profitable I hope you like it. Thanks, Erika
I am hoping to find someone with a report of patients by employer. We do a high volume of WC and continue to have employers change insurance carriers. We have to create a new case with new insurance carrier tied and trying to ‘remember’ which ones have changed etc has become problematic. Hilary
Does anyone know of a way to see which users have certain Custom Lists set as their default. I would like to delete old custom lists and I’m trying to find out who is still using them. Thanks!
Good morning Everyone, Does anyone have any forms, reports, or SQL queries for MU they are willing to share. Anything in general would be a big help, but Pediatrics specifically would be fantastic. With ICD10 starting to settle down. I’m trying to make certain we have MU covered. I’ve only been here for half a […]
Is there a way to print a patient’s appointment history individually in CPS 12? I have read all that GE supplies on the subject in their help icon on the desktop, and none are accurate. Any help is greatly appreciated. TIA! Alicia
Does anyone know of a report or have a custom report that will list referring providers and how many patients they’ve referred in a given time frame. Thank you!
Hello everyone, Does anyone have a report that you can run that would print out all of the medications in a particular physicians custom list. I have a doctor that would like to review what is in his custom list and I can not find a good way to present the information to him. Thanks […]
Hi. Does anyone know how to add a new report as an option the user can see when in a patient chart and they click on the Print button? I created a modified version of the probs.rpt form, and want to add it as a second option. It needs to be visible when the user […]
All, I’m constantly writing bizzarre SQL queries to pull data out of our CPS12 database and historically I’ve published them by excel, html and a plethora of other ways. This particular one, I was hoping I could do by Crystal Reports (in the EMR side of the house, not PM). I’ve successfully created the report […]
We inadvertently generated recall letters and the active report wrote back to the database. What do people do when this happens? Is anyone aware of a query/active report that can reverse the recall notes within the registration recalls that were added in error?
CPS 12 As of last week we are unable to preview/print any reports from the reports module (report mode). When we try to preview or print a report, a box pops up saying: Unable to preview report. Please contact system administrator. Every user is seeing this pop up. We are unsure of how to fix […]
Hi All, Has anyone ever created a report that can determine the WHO and WHEN related to the creating of a new Case, or changing the case information? We are unable to determine the when and the who for the changes. Our issue is that occassionally a user will change or create a new case in a patient’s registration […]
I need of a report that will provide a list of all prescriptions written (controlled substances and otherwise) by a specific provider and within a date range. Does anybody have one and is willing to share? Thanks!
We are banging our heads against a wall trying to figure out how to create a new report in CPS12. GE won’t even talk to us about anything relating to custom reports unless we give them money so we’re hoping someone else can point us in the right direction. We have a designer license, and […]
Hi Everyone, We are trying to find or modify our “Aging Report By Patient” to show a balance grouping for 365 days or longer. The current range in our report for CPS11.1 shows the last date range as 120days+ Has anybody modified a report for this or found a work around? It looked like the aging […]
I'm looking for anyone who has to submit GPRA measures. I am curious how they handle this since Centricity has no standard GPRA reports.
Hello Everyone, For those reporting on their own for PQRS, I am having trouble locating reports for the following in GE. If anyone has any information, I would appreciate it. NQF Report #0036-Use of Appropriate Medications for Asthma NQF Report #0083-Heart Failure (HF): Beta-Blocker Therapy for Left Ventricular Systolic Dysfunction (LVSD) Thank you! Rebecca […]
We would like to visit with someone that currently uses a report server for running crystal reports. I would like to put our IT manager in touch with someone who is currently using a report server. Thanks, Linda Keith lkeith@wtmedical.com 325-224-5793
Is there a limit to the number of records that CR will return in a report? I have a report that should be showing all patients in the database, but stops in the “E's” with only 153,246 records returned. No selection criteria, no filters/formulas.
I want to create a parameter based upon DOCUMENT.CLINICALDATE but CR is not allowing me to link the two via Select Expert. Help?
Looking for some guidance on formulating the Section Expert to suppress duplicate results. I had this in the past, but cannot locate it when I need it–typical. If I remember right, it looked at the previous line results and checked if it equaled the next line's, then either suppressed or displayed accordingly. Thanks […]
I'm in search of anyone who has created a Crystal Report to show in-process orders by provider. (EMR 9.5) Thanks!
I am trying to re-program our Service/Test/Referral/Rx forms to only display the last 4 numbers of patient SSNs and of their Insurance IDs. e.g. ***-**-1234 Does anyone know how this could be done in Crystal Reports?
Can anyone offer suggestions on how to learn to edit and create Crystal Reports? Do you know of any companies that offer training related to CR specifically for Centricity?
We have a request to add the provider's NPI# to our Test Order form in EMR. I cannot find the NPI field in crystal to add. I have DEA & License number, but no NPI. Help? Thanks, Sam EMR 9.5 / Crystal Reports 11
Report listing patients with non-ONC-specified values for the SMOK STATUS obsterm. Parameters include date of obsterm and location of care. The report is grouped by responsible provider and lists the clinical date and summary of the document the obsterm was entered in for the patient. Built for EMR 9.5 using Crystal Reports 11. […]
I'm running the GE MU Reports for Immunizations, and getting 0% compliance numbers. I've checked OBS terms, and most seem to match ok. I've also checked that the proper document types are included in the MU Document View. I must be missing something! Does anyone have any advice/tips??? Thanks in advance!!! Patty tmkhan@netsync.net
Does anyone have anything for creating reports in the CPS reports module? Any documentation showing the formulas and parameters to pass through to Crystal Reports? Been awhile since I have had to build one and just drawing a blank right now. Thanks,