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

Connecting Crystal Reports to CPS 12.0.7.1559

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

75 Views

RSS

jnelson

(@jnelson)

Posts: 2

New Member

Topic starter

Hello!

I have been trying to connect our SAP Crystal Reports 2011 to Centricity for quite awhile now with no success.

- Tried report user with password REPORT

- Talked with VAR who said they only use Crystal Designer

After modifying a report and pulling it back into CPS we get login denied messages.

If I try with certain db accounts I can get to the params area but then SAP CR 2011 always fails after submitting with messages like "Failed to retrieve data from database" and "Unknown Database Connector Error". I must be doing something wrong any assistance would be appreciated.

Posted : April 30, 2015 10:09 am

SLHV

(@slhv)

Posts: 478

Honorable Member

I haven't set up Crystal with Centricity. If your database is configured for AD authentication, you might try your domain credentials. If not, you'll probably need to set up a database account.

Posted : April 30, 2015 10:21 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

You need to connect to your sql server using a account with Read access to the database and then point to your CPS database in your sql server.

user one of your current ODBC connection, if there arent any one that you can use.

create one using the SQL 2011 driver that cps install on your computer.

1-Name your odbc connection
1-a) you dont need a description
1-b) type the name of your hostname of your sql server
--click finish

2- Use sql authentication, put the username and password of a SQL account that at least reading access to the SQL database.
--click next
3- change the default database or your CPS database name.
dont change anything else from that screen
--click next
4-dont change anything from that screen and click finish.

the odbc connection manager is located on
Click start-> Control Panel - > Administrative tools --> Data sources (ODBC)

point to your SQL server,with database "your cps database name"

Posted : April 30, 2015 10:36 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

The hell, all the formatting i did on that explanation went nowhere..

Posted : April 30, 2015 10:37 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

you can email me at [email protected] and i can send you some explanation with formating and Screenshot.
also please let me know what Operating system you are using on that computer to be able to help you better.

Posted : April 30, 2015 10:38 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