Notifications
Clear all
Topic starter
Hopefully an easy one. I've put together some custom reports that work in Crystal but don't work in cEMR when there's parameters in the SQL query. Here's the part that causing me a problem.
where RELPROV."PVID" = '{?Provider}'
It prompts for the Doctor, you select a doctor but the report is blank.
Posted : February 11, 2015 9:26 am
I asked your question and here is what one of my Crystal developers said:
"If they created the prompt fort eh name and not the ID number that is probably why it is coming up blank Apples and Oranges. They would need to change the RELPROV.PVID to however they set up the Prompt to look at."
Posted : March 30, 2015 3:34 am
Topic starter
Thanks David,
It should have displayed a drop down menu where they selected the provider from there. I might give that a try though.
Posted : March 30, 2015 3:44 am
