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

I have some SQL queries and crystal reports. Do I import the SQL into a crystal reports then into Centricity?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

94 Views

RSS

jpm1122

(@jpm1122)

Posts: 6

Active Member

Topic starter

I have some reports that run well in SQL Server but I want to import them into centricity. How do I do that with crystal reports? Do I need to link crystal reports to the database? Do I need to list all of the columns that the sql query touches?

What am I missing? Thank you!

Edit: So I was able to get a report working. I imported the sql using the command function in Crystal reports (in the database expert) and put those fields in and changed the parameters to match the ones that I changed in the report designer in centricity. That seems to all work but takes some time. This seems like it could take a long time, especially for more complex sql searches. Is there a quicker way to do this?

Posted : October 4, 2016 8:00 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

You have two options, you can use a Crystal Reports Command as you suggested or you can create a view based on the query.

If you put the words

CREATE OR REPLACE VIEW vViewNameGoesHere AS
SELECT * FROM TABLE

Then you can use the view as the source of your query. If you have Crystal report parameters, you have much more flexibility using a view than you do a command. I use a combination of both for our reports.

When you say it would take a long time, do you mean to create the crystal report or to run the query? You could probably use the new report wizard to create a report quickly that had all of the fields you needed after choosing the command or view as your source.

A couple things you should know about Crystal Reports if you are planning on importing them into EMR:

When writing SQL queries, Run your SQL queries as the report user, not the db admin. This is because the reports will be run in EMR as REPORT. (at least in C-EMR). This means that you do not have access to all tables such as those containing passwords. In CEMR there is a view called USRINFO that you would use instead of USR.

If you want your reports to show up in the EMR in Landscape you need to create a formula called mllandscape and leave it blank. Put it in your page header.

Posted : October 5, 2016 3:02 am

jryan

(@jryan)

Posts: 119

Estimable Member

Thx for including the tip on the landscape formula!! I write custom reports and a long time ago after one of their updates, our landscape reports stopped working and GE support told me there was no way for me to make it landscape again!

Posted : October 5, 2016 4:31 am

jpm1122

(@jpm1122)

Posts: 6

Active Member

Topic starter

This is a great answer, thank you. The time consumption I was talking about was in creating the crystal report. Specifically putting in all the parameters that are wanted in then report in crystal reports and centricity. Its just a bit of a pain putting the parameters in in two places - crystal reports and the sql statement in centricity.

The view option sounds great, I'll have to look into that since it looks like I don't have those permissions.

Thanks so much for the extra tips too. I was very confused why landscape was not working.

I'm still a little confused on the connection between crystal reports and the sql that is put into the "query" box in report designer, but I'm figuring it out.

Posted : October 5, 2016 5:11 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

As a followup, one issue I have found with landscape is that some print drivers do not work in EMR in landscape mode. For example if I use my HP printer I am able preview and print in landscape mode but if I try to use a Ricoh driver it will only work in Portrait. This is the same for preview and print.

Posted : October 5, 2016 5:40 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

You should not have to put any parameters in Centricity, just crystal reports (it will prompt you when you run it in Centricity for the parameter). I have never used the parameters within Centricity myself and I am not even sure how they work.

I am not sure what your last sentence is referring to. (query box? report designer?) Are you referring to something in Crystal or EMR? Feel free to send me an email with any screenshots on what you are confused on and I will do my best to help.

Posted : October 5, 2016 5:45 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