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

Crystal Report Help!!!

General Discussion

Last Post by gpincomb 9 years ago

4 Posts

4 Users

0 Reactions

58 Views

RSS

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

I am new to writing crystal reports. I was asked to make a report that will show how many MRIs were ordered to be done at our facility compared to those ordered to be done at an outside facility. I got it basically how I want, however, I noticed that a lot of patient orders were duplicated on the report. I believe I have narrowed this down to the fact that the documents are getting created by our scheduler and then signed by her and also the physician.
I would like to format the report so that it removes an entire detail line if the SDID of the order is a duplicate. Can anyone help me?!?

If it's easier to email me directly my address is [email protected] or you can call me at 913-319-7551. Thank you!!

Posted : March 15, 2016 11:23 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

use this formula on your section expert

Report-> Section Expert->

Click on Detail, click on Suppress (No Drill-Down)

Type this fomula: {PatientProfile.PatientId} = Next({PatientProfile.PatientId})

Replace the Patientprofile.patiend inside with the sdid colum of the tablet you are using.

example: Orders.sdid, your formula would look like

{Order.sdid} = Next({Order.sdid})

Posted : March 15, 2016 11:41 am

jsander

(@jsander)

Posts: 108

Estimable Member

There's also an option in the properties for each field. Right-click the object, choose Format, go to the Common tab and choose "Suppress if duplicated."

Posted : March 16, 2016 2:41 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Both of the other answers are great answers and will work fine in most cases, however, if you are working with a really, really large amount of data then your report could run for hours, maybe even just never finish. Another option, especially if you are creating a report that counts things, is to create a Command in the Database Expert ("Add Command" option under your datasource) and use that to code a SQL select statement that selects distinct data. This way you are doing your data gathering on the SQL server and paring down the amount of data that Crystal has to work with. Yes, I know that Crystal has the option to perform the Grouping on the SQL Server, but in many cases it is still best to create the report in this manner.

Posted : March 16, 2016 5:41 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