Notifications
Clear all
Topic starter
Can anyone tell me why when I create a Crystal Report based on a view, it works perfectly in the Crystal environment but when I run it through CPS it error's with
"Cannon retrieve the SQL Query, The table 'NAME' could not be found"
where NAME is a simple custom view? Tables do not seem to have this problem.
Posted : March 19, 2015 9:52 am
Topic starter
Got it!! For those of you wanting to create your own tables and views, Medicalogic created a user called MLReport that needs to have the "select" permission set. Apparently the system uses this account when pulling reports. Going to the permissions of new Views or Tables created, you go under permissions and add the role MLReport and give it Select permission and voila… it works!
Greg
Posted : March 19, 2015 2:08 pm
I would recommend that you login to your database in crystal using the report user. In CEMR (Oracle) The USR table is unavailable to the report user (in emr it is just "report" not "mlreport") because it has the password hash however there is a view called USRINFO that is the same table without that field and it is accessible to the report user. The first time I tried to create a report that utilized the USR table it took me a while to realize why it would not work. Now I always login using the report user and if it works in crystal it almost always works in EMR.
Posted : March 23, 2015 6:03 am
Also, one thing that I've noticed. If you go to CR , File then Options. Database tab. Make sure that "views" is checked. At the same time, if you notice that some tables are missing, I find that if you uncheck "views" then it should show you more tables.
Posted : March 24, 2015 5:09 am
