views:

29

answers:

3

Guys, i have a crystal report with a combination of database fields and static text. Is it possible to resize the field or reduce white space between these fields and the static text?

For ex: John works for "fieldA ", his title is "fieldB ".

In some cases, there is significant white space between the static text and the field, say when the fieldA value has only few letters.

TIA

+2  A: 

Is there a reason you are treating these separately?

For situations like this, you would typically make a static text box on the report, and drop the calculated field or database field directly into the middle of the text.

Alternatively, you could create a calculated field and include a formula: "John works for """ + {FieldA} + """, his title is """ + {fieldB} + """." (syntax will depend on the language being used).

Glen Little
+2  A: 

Drop the database field right inside the static text field. In that case, you can put the text in the static text field on either side of the database field and resizing is automatic.

Kangkan
A: 

To reduce the white-space, this answer might help.

KMan