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

Duplicate entries on custom imported Crystal Report

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

2 Posts

2 Users

0 Reactions

61 Views

RSS

bsamuelson

(@bsamuelson)

Posts: 1

New Member

Topic starter

Hello,

I am pretty new to CPS and Crystal Reports, but have a lot of DBA and reporting experience. I have created a custom Crystal report that looks perfect in Crystal Reports XI standalone, but when imported into CPS it duplicates entries. When running the SQL directly against the database it does not create the duplicates, so it's not the SQL.

Basically, the report is an analysis of patients/visits by referring physician, with referring being a multiple selection parameter. Each selected referring has a sub group by patient, grouped based on patient id. Then another sub group is visits by that patient, finally with the details of procedures listed under that group, including billing details.

The report displays wonderfully in Crystal Reports, but when imported it creates a duplicate entry for each procedure. It also places all visits by that referring under each patient, thereby exponentially increasing the amount of visits. For example, if Jane Doe had 3 visits, and John Smith had 4, then Jane displays with all 7 visits and John also displays with all 7 visits. You can imagine what the report looks like with 200+ patients... Each visit has each procedure displayed twice as well. So the summary of each patient group is twice what the summary of the whole referring should be. The group headers are formulas if that makes a difference.

Being new to Crystal Reports, I'm not sure how to start troubleshooting this. It seems to me like it's an issue with the grouping but I've changing every group setting that seemed applicable with no change. Any help or pointers would be appreciated.

-Brian

Posted : November 18, 2016 4:07 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Delighted to look at the report. Send me a copy.

Posted : November 18, 2016 4:28 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