database field in dynamic text from database?

[Former Member]

Using Crystal Reports 2011 Stand Alone

Is it possible to store a call to a database field in a database text string?

Example:

Report Database Field: Customer.Name

Text in another Database field like CustomerNotes.Notes "we should do this for {Customer.Name}"

So when the CustomerNotes.Notes is put into the Report it would fill in the Customer Name.

Thanks in advance.

[abhilash_kumar · Accepted solution]

Hi Kurt,

This can be easily done at the report level. Is there a reason you wouldn't want to pursue this method?

-Abhilash

[ido_millet · Accepted solution]

Create a formula in Crystal like this:

Replace({Customer.Notes}, "{Customer.Name}",  {Customer.Name})

[Former Member]

The reason for this is that we have some reps that want to have dynamic text in some reports that they can change but also access information from the database for standard items, prices, etc. The want to change it whenever they want. I have tried linking to WordDocs but have not been successful with the end formatting.

>>Ido your solution almost worked. CR wanted the last part to be a string so I just changed it to Replace({Customer.Notes}, "{Customer.Name}", ""& {Customer.Name})

and it worked perfectly.

Thanks.