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

Need help getting an old report working in CPS 12

Trading Post

Last Post by Anonymous 1 second ago

11 Posts

2 Users

0 Reactions

64 Views

RSS

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

I have an old report that was written before my time.

It has a group by that no longer works.

Here is a screen shot:

Here is a screen shot of the code for the GroupBy:

Any suggestions as to what to check would be greatly appreciated.

Posted : September 2, 2014 2:50 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

In addition the G.XXX moves up and down the list when you move over the add and remove buttons.

Posted : September 2, 2014 3:04 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

I can't see either of your screen shots. Tried three different browsers.

Posted : September 4, 2014 5:00 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

Try 2 on the images.

Posted : September 4, 2014 5:32 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Can you provide the report query?

Posted : September 5, 2014 10:16 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

ronmoses,

Sorry or the delay in response.

I PM'd you with the SQL code.

Posted : September 30, 2014 3:05 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

Okay, I have the code, so let's get into some specifics:

1. When you say the group no longer works, what exactly is happening?

2. "In addition the G.XXX moves up and down the list when you move over the add and remove buttons." I'm not sure I'm picturing what you mean. Can you provide some further detail on that behavior?

Posted : October 3, 2014 12:53 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

When you select one of the G.XXX codes, it moves to the bottom of the select list, but it does not show that you selected it.

Posted : October 3, 2014 1:02 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

jkratzer said:

When you select one of the G.XXX codes, it moves to the bottom of the select list, but it does not show that you selected it.

So you click on G.Doctor, and the list is reordered so that G.Doctor is at the bottom? Or are you clicking Add at some point in this process? I'm just a bit confused about the steps.

Posted : October 3, 2014 1:06 am

jkratzer

(@jkratzer)

Posts: 138

Estimable Member

Topic starter

It moves down when you select add or double click it.

Posted : October 3, 2014 1:15 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

jkratzer said:

It moves down when you select add or double click it.

But it does not add to the right-hand list? Hmm, that's weird. The one thing that looks off here is the "G"s in the selection list. I'm not sure why they're there. Try this: In your control properties (the other dialog you posted), put curly brackets around the field names so it looks like this:

Doctor^{d.ListName}|Financial Class^{f.Description}|Department^{dp.Description}

See if that does anything.

Posted : October 3, 2014 1:36 am

Share:

24 Forums
9,942 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