formating help. 1

[jcisco]

I am trying to format my report for customer address. Now i found this thread that tells me how to do this but i'm having a small issue with it (thread767-560095). I am using crystal 8.5.0.218 and when i click on my text object and go to the format editor i do not see suppress blank lines, i only see Suppress and when i click on that it suppress everything. is there somewhere else i suppress it at? also will this fix the city state problem that i'm having. right now it looks like this.

someCity SomeState
but i would like this
somecity, somestate

thanks.


--------------

 

[vidru]

When you're formatting the text object, at the bottom of the Common tab, there should be two checkboxes there: 1) Suppress if Duplicated, and 2) Suppress Embedded Field Blank Lines.

You want to check Suppress Embedded Field Blank Lines.

-dave

 

[jcisco]

nope only have one. Suppress IF Duplicated then off to the right side of it there is the X+2 button. that's all.

--------------

 

[bdreed35]

I don't believe this option is available for database fields that are just dropped on the report. You need to have a text object with more than one line in it, like text or database fields seperated by a carriage return (the enter key).

Also, this option will not correct embedded spaces between 2 fields on the same line. You may need to create a formula for this:

Trim(table.city) + ", " + Trim(table.state)

Now drop this into your text box instead of the 2 individual fields.

~Brian

 

[jcisco]

that worked thanks!

--------------