Cariage Return

[vsharma79]

Hi!

Forgive my spelling. I would like to know if you can use a carriage return while designing Crystal reprots, for wider columns. To make it easy to understand what I'm trying to achieve, here is an example.

In my Report, I have the following fields.

Name varchar(40)
State varchar(5)
Address varchar(255)
City varchar(20)

You will notice that Address is the one with the longest length.
Right now my report looks like this(in Crystal reports and Crystal viewer)

Name State Address City
Vik NSW 23/54 James Rus Sydney

In actual fact, it should come up like this

Name State Address City
Vik NSW 23/54 James Ruse Sydney
Drive,Cnr of Sick
and True Road

How do i get it to come out like this? Which means I have to use some sort of carriage return for the address field while designing in crystal reports, so that it brings everything out in the address field, on the screen. I realise that even if I use the first design and export it into excel from Crystal, it will bring up everything thats in the adress field of the table. But how do i get to view everything in Crystal. The only way I thought about doing it would be a carriage return(using the next line on that column only). How do I do that? Considering I can only use A4 Landscape format, increasing the width of the column in Crystal is not an option.

Help Please!!!!

Vik

 

[synapsevampire]

You don't need a carriage retrun, what you want is to size the field horizontally and formt it with CAN GROW (right click the field and select FORMAT FIELD->Can Grow.

It will preserve the width, yet increase the height accordingly.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[vsharma79]

You are an absolute legend.Thanks a lot for all your help.Just one more question? How can I get a border around each row.If you know what I mean. Now that I know how to get all the info to appear in the column, I just wanna have a border around each row, to seperate it from the next row.Any ideas???

Vik

 

[klameer]

Go to format field and click the border tab. This gives you border options

 

[Naith]

If you want to have a border around the row, as opposed to around the fields, as the previous post shows you, then you can go to the Insert menu, and select Line, or Box accordingly to accent the details section as you see fit.

Naith

 

[vsharma79]

For some reason, the line or Box did not seem to fit correctly. It does not include all the values in the field for which the size "can grow". Any ideas?

Vik

 

[chelseatech]

Lines and boxes can span several sections, but work best when they go from a section to a matching end section.

Ie. line or box from GH2 to GF2 works as you would expect.
Line or box from GH1 to GF2 only displays for the first group 2 of group 1. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[goranm]

Hi !

Maybe this can help you.

If you create another detail section and drag the bottom of the box to the top of the new section and then resize the new section as narrow as possible then I think you will get what you want.

/Goran