Notifications
Clear all
Topic starter
Appreciate any direction - we have been working on a PCMH report that lists the schedule with services/screenings due. Report works well in Crystal. To write we used a view. Installed on the EMR side - Centricity can not see the view and receive an error - table not found- any ideas?
We rewrote the query using the add command in Crystal to bypass the view. Again works in Crystal but on the EMR side now receive a "command text" error. I would greatly appreciate direction.
Posted : October 31, 2012 3:05 am
Oracle or SQL? Assuming by view you mean custom tables... did you create and save the custom tables in the DB?
Posted : November 6, 2012 7:06 pm
Topic starter
Finally figured out - for Centricity to access a custom view or table, in SQL management studio under view properties, permissions to Select need granted for "mlreport"
Posted : November 10, 2012 8:28 am
