Notifications
Clear all
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
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
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
Topic starter
A complete uninstall/reinstall of Crystal resolved this issue.
Posted : March 23, 2015 5:03 am
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
