Search results for query: *

Crystal 10 & SQL 8 I am creating two parameters in a report. The first is a customer name. The second is a order name. I select the table and then the field within that table and I get all my customer names returned. But when I go to my order name field within the same table, Crystal returns...

Thank you for your response - it was because I was using it in format editing not a standalone formula. I will remember to include more information if I have any additional questions.

I did a toText - if ProperCase ({jomast.fpartno}) >= "a" then ToText(DateValue({jodrtg.fcomp_date})) else "" but now I get "The formula result must be a boolean" The same messege occurs when I take the else out of the statement.

In the "Format Formula Editor" I am trying to suppress a dateTime field. What do I use at the end of this formula instead of the "", which does not work for dates - if ProperCase ({jomast.fpartno}) >= "a" then DateValue ({jodrtg.fcomp_date}) else "" //the error is "a date is required...

We need a formula to enable us to eliminate the unnecessary data and just return the current work center. Table “jodrtg” is were the data pertaining to operation number, work centers, and routing reside. In the column “foperno” the table lists all of the operations that a single work order (job...