Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Crystal Views

General Discussion

Last Post by wsc27 10 years ago

4 Posts

3 Users

0 Reactions

56 Views

RSS

gfishback

(@gfishback)

Posts: 70

Estimable Member

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

gfishback

(@gfishback)

Posts: 70

Estimable Member

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

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

wsc27

(@sclayton)

Posts: 142

Estimable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0