Notifications
Clear all
Topic starter
Has anyone be able to create a report in the EMR with date & text parameters? I am able to get the date parameters to work correctly, but not any text parameters. See screenshot file....
Any suggestions or assistance with this would be appreciated. 
Posted : January 11, 2021 9:23 am
Topic starter
I am still not having any luck with this, if someone could reach out I'd appreciate it.
I have found a report where the text parameter works. I reviewed the report & I cant get it to duplicate and work. I have made sure that the formula name matches the formula used in the crystal report. The report still runs wide open & not with the filtered parameters that I set it to.
Posted : January 12, 2021 8:27 am
Topic starter
Update - I was able to figure out the issue. Here is the fix in case others are following this post.
Within Crystal Reports, set the formula variable to whichever table.field. Ex: Formula1: {table.field} Then for the selection criteria use {table.field} startswith {Formula1}.
Within EMR make sure that the formula name matches up with crystal and emr when entering the report paramters. Keep in mind that the text parameter is case sensitive. 
Posted : January 15, 2021 2:31 am
