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 - EMR 9.8 - FILTER Parameter - LOC then by Provider

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

54 Views

RSS

gdmitchell

(@gdmitchell)

Posts: 15

Eminent Member

Topic starter

I am working on a Crystal Report where I want to FILTER a Parameter.

I want to have a report that multiple LOC (searchable) can use but only are able to view the providers at their location of care.
I need to filter out the LOC that are NOT active.
I need to filter out the Providers (currently doing it by NPI) that are NOT active.

I started by doing this…..but it only retuned a short list of LOC (from some unknown reason) not ALL.

LOC SIDE
Looking at: LOCREG.STATUS = "A"
The end user should search: Displaying both - LOCREG.ABBREVNAME & LOCREG.NAME
USER SIDE
Looking at: USER.STATUS = “A”
The end user should search: USERINFO.NPI Displaying ONLY - USERINFO.SEARCHNAME

I would like to just display the latter 2 in the parameters, but cannot figure out how to FILTER the parameter.

================================================

I then created seperate commands to populate the parameter with only active LOC and active Providers

================================================================================================

The above formula to filter only the Active status of the two fields work.
However, the data is not coming across properly.
They work wonderfully BY THEMSELVES…..(1) and (2)

Together(3) the data does not display properly….
I wonder if that is because we are using Oracle on EMR?

1.
Location of Care – By itself - Works FINE

2.
Providers – By Itself -- WORKS FINE

3.
Combined
Location of Care – Only shows ONE Location

Providers – Shows ALL the providers, NOT just the providers at the one Selected Location of Care

Any thought would be appreciated.
I cannot imagine that I am the only one that ever wanted to do this.

This would help consolidate a LOT of Crystal Reports, if we could get this to work.
Please contact me with any questions.

Cordially,
Greg Mitchell
Freeman Health System
417-347-4922

Posted : July 2, 2015 11:57 am

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

Could you copy and paste your complete logic so that I can help troubleshoot this better?

Posted : July 6, 2015 2:33 am

gdmitchell

(@gdmitchell)

Posts: 15

Eminent Member

Topic starter

PERSON.PID --> DOCUMENT.PID
DOCUMENT.SDID --> OBS.SDID
OBS.HDID --> OBSHEAD.HDID
USRINFO.PVID --> DOCUMENT.USRID
USRINFO.HOMELOCATION --> LOCREG.LOCID

I made 2 Commands in the Database Expert:
1. (Command) SELECT ABBREVNAME,NAME FROM ML.LOCREG WHERE STATUS='A';
2. (Command_1) SELECT NPI,SEARCHNAME FROM ML.USRINFO WHERE STATUS='A';
...to pull ONLY the ACTIVE (1) Locations of Care and (2) Providers

The IDEAL Parameter.....(Dynamic)
Command.ABBREVNAME (Value) - Command.NAME (Description)
Command_1.NPI (Value) - Command_1.SEARCHNAME (Description)

This SHOULD provide me the list of active Location of Care.
Once Selected, the 2nd level parameter SHOULD provide me a list of active providers AT that one location of care.

It does not.....as stated above....

I could not copy any screenshots here, but would be more than happy to do that via regular E-mail.

Would you be willing to provide your e-mail?
or...
mine is [email protected]

Thanks in advance for the assistance....
Cordially,
Greg Mitchell

Posted : July 6, 2015 3:14 am

Share:

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