Member since ‎07-19-2013

User Statistics

  • 171 Posts
  • 1 Solutions
  • 1 Kudos given
  • 2 Kudos received

User Activity

I am getting this error after generating my SQL command. Any ideas on where my issue is ? Attached is my
I am trying to capture a number value based on when two times occurred. So I need the value that was recorded for the LAST meas.RECORDED_TIME that occurred before the Administration Time of a Medication. I am using the function 'Max' for my meas.RECO...
Keep getting a Crystal Error and trying to figure out what I am missing ??? pain-crystal-sql.txt
I have a Crystal report that looks at some lab items. These are located in a details section. I want the report to only look at certain lab items so I tried a formula to only look at those items which works but I still get the patient name. I don't w...
Is there a way in Crystal where to only display the patients that has both Lab Tests for example. So I only want patients that had Lab test "24" and Lab Test "1230100146". The in statement just seems to give me both. Thanks.
Kudos from
Kudos given to