Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Formula for text object?

I'm looking a Crystal Report that someone else wrote (I'm very new to Crystal) and can't work out what a particular field is doing!

I see that you can look at the formula for a field by right clicking and looking at 'edit formula'. However, the option isn't there for this field (it's a text object I think). However, I know that that its value does change - but I can't find what it depends on.

How do I find this out? The text in the template starts with a '@' if that means anything.

Thanks!

like image 669
OMill Avatar asked Jan 05 '11 10:01

OMill


People also ask

What is text formula in Salesforce?

Common Text Functions and Operators Salesforce comes with many functions and operators that make it easy to work with Text in formulas. Using formulas, you can convert other data types to Text and concatenate Text values together or search for a specific string within a Text field.

How do I convert a formula field to a text field in Salesforce?

how can we change field type of formula fields? Sorry,Formula fields type cannot be changed to anything else. You will need to create a new custom text field to use instead.


1 Answers

Well, you seem to be off to a good start with Crystal, at least. 3 Possibilities come to mind:

  1. You are looking at a "Field" object. In this case, you can try Right-click->Edit Formula. (except you already did that, so we can skip this step).

  2. You are looking at a "Text Object" into which the previous designer dragged & dropped a Formula. In this case, Double-click the text object to find the complete name of the formula and look it up in the Field Explorer.

  3. Many objects (including the 2 I just mentioned) allow you to overwrite the standard text based on whatever condition you like. I try to avoid this myself, but you can right-click->Format Field/Text/Whatever->Common and see if there is a custom formula for Display string.

Based on your description, #2 seems the most likely. Try that one first.

like image 148
PowerUser Avatar answered Sep 20 '22 18:09

PowerUser