Database field inside text object does not display

[MSProg]

I am trying to embedded couple of database fields inside a text object for display. However, it only displays [] brackets for all the fields inside the text object. Please help.

 

[synapsevampire]

What are the field types, and the version of Crystal?

Is the text object formatted to Can Grow?

-k

 

[MSProg]

Thank you for your reply.
The version for Crystal is 7.0.1.200.
The field types are char and varchar.
I originally have the can grow option checked and I also took that out but it still doesn't work.
I am trying to accomplish exactly what is being described in this article:

http://support.crystaldecisions.com/library/kbase/articles/c2010280.asp

The weirdest thing is that when I copy the crystal report and use odbc connection to view the report, anything is ok. However, if I view it from Macola, all the fields inside the text objects are displayed as brackets only [].

 

[dgillz]

There is a much easier way to do what you want to do, IMHO. Here is an example:

Section Field
PH a Cust_Name
PH a Address_1
PH b Address_2
PH c Address_3 (aka City, State, Zip)

Notice that the field that is sometimes blank, Address_2, is in a section all by itself. Then simply format that section to "suppress blank section" This will have the effect of giving you a 3 line address with no white space when there is no data in Address_2. If there is Data there, it will give you a 4 line address with no white space.

Here are sample outputs:

3 line address 4 line address
ABC Company XYZ Corporation, LLC
1234 Main Street 29000 S Meridian Street
Daphne, AL 36526 Suite 6104
Indianapolis, IN 46845

I have a sample of this for a Macola RMA form that we developed for another customer. If you are interested let me know and I can email it to you.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MSProg]

Thank you dgillz. It works.