Conditional Size of Field 1

[jbenson001]

Hello,

I have a report I am using in VS2005. I have address fields being populated from a db. What I would like to do is to adjust the width of the City column so that the City and St fields are right next to each other:
MyCity, NJ 12345
This Other City, NY 12345

is there a way to do this?

Thank you,

Jim

 

[synapsevampire]

Generally you use a formula to concatenate the fields, as in:

{table.city} & ", " & {table.state} & " " & {table.zip}

Youj can also drop the city field into a text box, ad a comma and a space, then drop the state, add 2 spaces, then drop in the zip.

-k

 

[jbenson001]

Thanks. I figured out a way to do it with the SQL too. I just figured that CR would have the abiliby to "slide" columns over depending on length.
Thanks for your help,

Jim

 

[jbenson001]

I used your suggestion about dropping the fields into a textbox with the comma and space. Works perfectly!

Thanks again

Jim