Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Finding the EMR Report Path

General Discussion

Last Post by jryan 9 years ago

8 Posts

6 Users

0 Reactions

67 Views

RSS

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

When one looks under Administration-Reports-ClinicalReports for the EMR crystal reports and then you highlight the report in question and click "change" just to get the actual path and filename of the report being used, the path is longer than the pathname field, you can't select, enlarge or scroll to the right so it cuts off before it finishs the crwrpt\ and you are unable to identify the name of the report. I just spent the better part of an hour digging through the table structure to try to figure out where they store that data to no avail. Is there an easy way to get the entire report name out of the system be it by SQL or hovering over some link. Trivial but it is driving me nuts!

Posted : December 11, 2015 9:18 am

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

If you have a fat client installed all reports that are in the system will be stored in a folder called "crwrpts".

Posted : December 11, 2015 10:09 am

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

This I know. Maybe I'm not being clear in my explanation. When I look at the form properties the full path and file name do not display because c:\program files (x86)\centricity practice solutions\client\crwrpt\filename.rpt is chopped off right after the C of crwrpt so it does not display which file is in use. That feild is not selectable so one cant sroll to the right to get the file name. With many custom rpt files not named very well, it would save me a ton of time to be able to find the actual filename.rpt somewhere.

Posted : December 11, 2015 10:19 am

lhess

(@lhess)

Posts: 27

Eminent Member

I had the same problem. Create a clinical kit with all your reports (Go-Setup-Settings-Export Clinical Kit-Report-Add All). The file in the kit named "All Reports.ckt" will contain the actual crystal report file names. Here's an excerpt from the ckt file, you can see that report "Uncoded Miscellaneous Codes on Custom Lists" in folder Reports--> Medicalogic is pointing to uncmisc.rpt

[RPT][1][Uncoded Miscellaneous Codes on Custom Lists][Reports, MedicaLogic][uncmisc.rpt][][0][0]

Posted : December 11, 2015 10:46 am

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

Well no, THAT Sir, fall firmly into the "why the heck didn't I think of that catagory". Genius... pure genius.. 🙂

Thanks a ton. I'm still gonna find it by SQL someday. That's where I live but this gets me quickly where I need to go.

Greg

Posted : December 11, 2015 10:51 am

tmarkovina

(@tmarkovina)

Posts: 20

Eminent Member

You can also just re-name the crwrpts folder on a fat client. When you open the reports section again and click ok to the screen with the chopped off path, it will display an error message "cann't find reportname.rpt"

Posted : December 11, 2015 11:46 am

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

I believe you would need to use the HIEROBJS table and the RPTPROP table to get the name of the report and the file name of the report.

Join on object id.

the full path is probably run time populated in the application.

Posted : December 11, 2015 12:48 pm

jryan

(@jryan)

Posts: 119

Estimable Member

SELECT RPTPROP.RPTNAME, HIEROBJS.NAME
FROM ML.HIEROBJS HIEROBJS INNER JOIN ML.RPTPROP RPTPROP ON HIEROBJS.OBJECTID=RPTPROP.OBJECTID

I believe this will get you the list of report name (*.rpt) and the name as it shows in EMR and the path is the default crwrpts location. Thx

Posted : December 15, 2015 7:33 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
6 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0