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

Seeking Crystal Clarity

General Discussion

Last Post by rwilliams 10 years ago

5 Posts

4 Users

0 Reactions

89 Views

RSS

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

All,

I'm constantly writing bizzarre SQL queries to pull data out of our CPS12 database and historically I've published them by excel, html and a plethora of other ways. This particular one, I was hoping I could do by Crystal Reports (in the EMR side of the house, not PM). I've successfully created the report in the crwrpt folder and can view it but I have no idea how to pass variables such as one from a drop down list where the user can select a particular clinician or date range etc. and have that data pass to a variable within the RPT file. Where can one find that educational?

Posted : March 17, 2015 10:55 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

These are very fundamental capabilities of Crystal. It is an incredible data extraction and presentation tool. Once you use it, you will never go back to Excel or anything else. There is no better way to learn than to sit down with Crystal, ask how can I do whatever, and then either search the web, open a reference work, or the click on the help files. Crystal is relatively intuitive, but there are clearly some initial hurdles you must overcome. I have used "The Complete Reference, Crystal Reports, McGraw Hill". My bias is to read the reference with no expectation of retention of information, just the knowledge that the information is there. If you need any specific help, feel free to contact me.

John W. Fitzgerald, MD

[email protected].

Posted : March 17, 2015 11:31 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

Create a Parameter (ex: OBSDate). Then in your selection criteria, set the OBSDATE = Parameter. When the report runs inside EMR it will prompt you to enter a date. There are more flavors to it if you want multiple values, default values or have to convert datatypes (ex: DateTime to Date), but the prompts work.

Posted : March 18, 2015 5:17 am

gfishback

(@gfishback)

Posts: 70

Estimable Member

Topic starter

Thanks Guys, very much. I'll do some more playing. I've used Crystal successfully multiple times an I agree, it is fairly straight forward but my question was more about integrating the two. I don't imagine the crystal documentation is going to help much with tying it to Centricity conditions but I'll see if I can integrate James' comment. When identifying the variable, you don't have to declare it, enclose it in brackets or add some funky symbol to tell it to treat it as a pass through variable?

Posted : March 18, 2015 6:51 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

If you setup parameter fields and then use them within the report (usually on the Record "Selection forumula") you will be promted within centricity with a crystal report popup asking you to fill in the parameters. As long as you can run the report within crystal, you should be able to run it in EMR. (make sure you used the report user to log in to the database, not the db administrator)

Posted : March 24, 2015 7:45 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