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 Reports Error in CPS "The field name is not known"

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

68 Views

RSS

Jim Poulos

(@jpoulos)

Posts: 118

Estimable Member

Topic starter

Happy Friday Chuggers:

I have created a report in Crystal Reports Designer and get the results I want running it directly in Crystal. When I attach this report into my CPS system, I get the following error. Any ideas?

An error occurred while running the report file 'xxxxxxx.rpt":

Any one ever run into this situation? I am pulling out my hair and am going crazy.

Posted : November 18, 2016 6:11 am

Jim Poulos

(@jpoulos)

Posts: 118

Estimable Member

Topic starter

Uggh It appears that the original posting has dropped half my message off.

An error occurred while running the report file "xxxx.rpt"

Cannot set the record selection formula

Crystal Reports returned this error

This field name is not known

Posted : November 18, 2016 6:13 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Post the record selection formula.

Posted : November 18, 2016 6:17 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

This often happens to me when a table or view is not accessible via the report user. I use Oracle but I am sure it would be similar in SQL server.

Do you write your reports in crystal using the Report user/pass or do you use a database admin user/pass? You should be using the report user if you are not. One example in CEMR of a table that would cause this issue is the USR table. (or any table that contains a password hash) In CEMR you have to use the view USRINFO instead of the table USR within Crystal reports.

Posted : November 21, 2016 3:46 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