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

The remaining text does not appear to be part of the formula crystal report.

Trading Post

Last Post by Anonymous 1 second ago

5 Posts

4 Users

0 Reactions

81 Views

RSS

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Topic starter

I've been getting this error on a report whenever I use a formula of any kind in it. I've tried a formula that just has "hey" in it, and I still get this error. So, I'm thinking something is messing it up within CPS. Anyone else ever seen this error message while running a report in the Reports section of Centricity?

Posted : March 12, 2013 12:13 am

Sam

(@sam)

Posts: 371

Honorable Member

I have, but it's been a result of a formula error on my part, not CPS. Confused

Posted : March 12, 2013 1:43 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Probably need to see the code to understand.

Whenever I have gotten that error, it has been related to spacing on my syntax, or missing a punctuation of some kind.

Posted : March 12, 2013 11:11 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

I agree with all the posts. Check your "'" and , and any other punctuation you may have as well as any If then elses.

Posted : March 13, 2013 8:37 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Topic starter

Here's what's causing this error:

I have a control called RESOURCE that is a "Select, Resource". For the SQL query I am using RESOURCE.ITEMDATA.U in the WHERE clause and for the Crystal Report I am using RESOURCE.TEXT (to show which resources have been selected). Whenever I usually do this, I make RESOURCE.TEXT a Formula and RESOURCE.ITEMDATA.U a Parameter in "Parameters and Formulas"; however, if you add a formula to your crystal report (regardless of what's inside the forumla) with this setup, you get the error "The remaining text does not appear to be part of the formula".

I've tried swapping RESOURCE.ITEMDATA.U to being a formula and RESOURCE.TEXT to being a parameter, but it has the same outcome. If I make both a parameter, it will use RESOURCE.ITEMDATA.U in the Cyrstal Report instead of RESOURCE.TEXT. If both of them are formulas, RESOURCE is never sent through to the Crystal Report. So, I'm a bit stumped on how to make this report work and show which resources were selected at the top of the report without putting them in the details section with everything else.

Posted : March 14, 2013 12:15 am

Share:

24 Forums
9,942 Topics
39.9 K Posts
0 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