Notifications
Clear all
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
I have, but it's been a result of a formula error on my part, not CPS. 
Posted : March 12, 2013 1:43 am
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
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
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
