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

Crystal Report works in CR, errors in CPS

Trading Post

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

85 Views

RSS

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Topic starter

This has never happened to us before, and I'm getting extremely frustrated with it.

I have a report that I've based on a stored procedure called rpt_CMC_PatientPanels. The report works flawlessly in Crystal.

In CPS, the parameters window comes up, but once you enter your parameters and click OK, you get the error:

---------------------------
Centricity Practice Solution
---------------------------
An error occurred while running the report file 'panels.rpt' :
Cannot retrieve the SQL query
Crystal Reports returned this error:
The table 'cmc_RPT_PatientPanels' could not be found.
---------------------------
OK
---------------------------

We don't have this problem with any other SP-based report. As far as I can see, all permissions are set the same on this SP as any other we use. Does anyone have any thoughts about what we could look at?

Posted : March 20, 2015 6:52 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

This problem has been raised in the past, and was felt to be a permission issue. In Crystal, what is your data source? If this is not a permission issue, why not create the view in Crystal. Should be a very simple translation of the stored procedure to linked tables. I'm interested in the resolution of your issue.

Posted : March 20, 2015 7:36 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Topic starter

We only use stored procedures when Crystal is inadequate to the task, which is most of the time for us. Believe me when I say this would not be a simple translation to table links.

I believe it has something to do with the ODBC data source used to create the report. Even if I create a new report that uses a stored procedure that is running fine in an existing report, I get the error in the new report. Yet I don't get the same problem with tables or views. I got a new computer a few weeks ago, and had to recreate the data sources, so I'm guessing that must be it. I just don't understand why they run fine in Crystal.

Posted : March 20, 2015 9:11 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Topic starter

A complete uninstall/reinstall of Crystal resolved this issue.

Posted : March 23, 2015 5:03 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Make sure that you are using the username "report" in crystal when you are designing your reports because that is what it is run as in CPS/EMR.

Posted : March 23, 2015 5:14 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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