Notifications
Clear all
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
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
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
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
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
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
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
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
