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

Grouping in a Referrals Report

Trading Post

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

82 Views

RSS

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

I have a referrals report that is perfect except that since it is grouped by BUSINESS_1.SEARCHNAME (which is primary insurance) the patients without primary insurance never show up. In this case the left outer join doesn't seem to help. Is there an easy way to make them appear at the beginning or end of the report somewhere?

Posted : July 31, 2013 11:27 pm

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

Left-outer joins in Crystal won't work if you use the outer table in your criteria/formulas. If you are just displaying the 'outer' information, however, the join should be OK.

-- the amount of hours wasted on this issue, for something that only takes moments to do in Oracle, Access or MS... If you google this, you'll see lots of items.

Depending upon your situation:

1. You could use a running-total function

2. You could use the Section to suppress excess data, even though the data is still there.

3. You could create variables to pass the information back from a subreport

4. You could create a View with the data you want outside of Crystal

5. You could use the Crystal SQL Command (which nominally is similar to a View although I find it doesn't work quickly)

[email protected]

Posted : August 13, 2013 4:20 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Thank you, I actually have a Crystal Reports class tomorrow so I will bring your ideas and the report along with me to see if I can figure this out.

Posted : August 13, 2013 4:48 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

By the way, have you ever used Access with Centricity? I have never tried it with Centricity but I do use it for other databases. I use MS Query sometimes for my reports, maybe I can try it in there too if I can't get Crystal to work.

Posted : August 13, 2013 4:54 am

Jim Lawhon

(@jlawhon)

Posts: 39

Trusted Member

I have used Access for years. I am not good at sql and I like Access better than Crystal. The one issue I had on the Oracle database is when Centrcity went from a 32 bit server to a 64 bit server the normal ODBC connection did not work well since my Access application is a 32 bit application. I had to create a separate ODBC connection to use with Access on the large tables. Jim [email protected]

Posted : August 14, 2013 12:26 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Thanks! I think I will give Access a try then

Posted : August 14, 2013 1:02 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