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

Cystal Reports - How can I access data from two separate databases?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

89 Views

RSS

jeisenmann

(@jeisenmann)

Posts: 10

Eminent Member

Topic starter

We have a need to pull data from the centricityps database and another database onto the same crystal report. Both databases reside on the same SQL server. The report functions properly inside Crystal Reports. But once it is imported into CPS it will not pull the data.

When we try to run the report it will ask for the report parameters as expected. Once the start and stop dates are entered the report attempts to run for a second but then returns an error that reads "Failed to retrieve data from the database." The error message does not specify which database. I can only assume it's failing to pull data from the non centricityps database.

I'm thinking this could be a SQL permission issue, but I don't know which SQL account is used by CPS for reporting. Has anyone else seen this before?

Posted : February 6, 2019 1:31 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I think you state that the Crystal Report functions when run on a specific computer, (assumed) with ODBC connections defined to point to extra data environment.

So, how do you run CPS? Do you use a Citrix environment? Just thinking that perhaps that environment does not have the ODBC connection defined?

Posted : February 6, 2019 2:29 am

SLHV

(@slhv)

Posts: 478

Honorable Member

I'm also thinking you have an auth issue. If you look at the SQL event viewer, you should see which account is being denied access to the database. I don't recall offhand which account CPS uses for database queries though. Perhaps "cpsuser".

-dp

Posted : February 6, 2019 3:09 am

jeisenmann

(@jeisenmann)

Posts: 10

Eminent Member

Topic starter

Sorry if I was unclear. The Crystal Report works when I preview it within the Crystal Report application. Yes I am using ODBC connections defined for both databases. The report does not function once imported into CPS.

We are not using a Citrix environment or terminal servers. CPS client is launched on the local workstations.

Posted : February 6, 2019 3:27 am

Share:

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