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

Sorting on a column based on a formula.

Page 2 / 2 Prev

Trading Post

Last Post by Anonymous 1 second ago

25 Posts

2 Users

0 Reactions

201 Views

RSS

jjordet

(@jjordet)

Posts: 545

Honorable Member

You will be able to link like you do now, just to the view instead of the DOCUMENT table itself. The SELECT a.* will return all fields from the DOCUMENT table.

Posted : September 13, 2012 11:05 pm

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

I am going to try to do it as you suggested. Thank you very much, JJ.

Posted : September 13, 2012 11:18 pm

jjordet

(@jjordet)

Posts: 545

Honorable Member

You'll want this to get only office visits:

SELECT a.*

FROM ml.DOCUMENT AS a

WHERE a.DOCTYPE = 1

AND a.CLINICALDATE = SELECT MAX(b.CLINICALDATE)

FROM ml.DOCUMENT AS b

WHERE b.PID = a.PID

AND b.DOCTYPE = 1

Posted : September 13, 2012 11:34 pm

jjordet

(@jjordet)

Posts: 545

Honorable Member

You'll want to call the view something like LASTOFFICEVISITS.

Posted : September 13, 2012 11:36 pm

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

How do I create a view as you said? When you gave the SQL, I was going to do with Add Command. Could you please give the specific steps needed?

Posted : September 13, 2012 11:44 pm

jjordet

(@jjordet)

Posts: 545

Honorable Member

I usually have our DBA create any views that I need for reporting...don't have direct access myself...so not sure of exact syntax or process.

Posted : September 13, 2012 11:48 pm

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

I also do everything from inside Crystal Reports. But I'll try to incorporate the code you gave inside the Add Command so I can filter only the last office visits. I feel it will work. Thank you again, JJ.

Posted : September 13, 2012 11:57 pm

jjordet

(@jjordet)

Posts: 545

Honorable Member

I didn't know about the Add Command feature...might come in handy later.

Posted : September 14, 2012 12:07 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

JJ, That is a very useful feature I have come across in CR. I have used it before. What I usually do is create a report in CR like a normal report linking tables needed adding selection criteria,etc and then copy and paste the SQL into a new report, so I can use it to get dynamic (and sometimes cascading) parameters.

One eg. was when I wanted to pull appointments of patients at a particular location having certain procedures on a selected date (parameter) and select a provider(parameter -who has patients scheduled on that date) and get selected patient(parameter). This is a dynamic cascading parameter. ApptDate > Provider > Patient

I can help you(with whatever I know) if you need any help.

I would like to know if anyone knows if there is a way to create a view as JJordet said from inside CR and link other tables to the created view in a way that we link tables.

Posted : September 14, 2012 12:31 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Hi JJ,

Sorry for the late reply. But just wanted to let you know I could not do it within Add Command. It was giving an error. I do not have access to create view. I am going to ask for it.

Regarding the report, since we needed the first 100 patients who were last seen, I ran the report for each day individually and gave the list.

Thank you once again for your help.

BAJ

Posted : September 17, 2012 5:26 am

Page 2 / 2 Prev

Share:

24 Forums
9,942 Topics
39.9 K Posts
10 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