Notifications
Clear all
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
Could you copy and paste your complete logic so that I can help troubleshoot this better?
Posted : July 6, 2015 2:33 am
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
