Report Format 1

[roseMay]

I have a report was asked to be formatted to wrap columns to the next line when the column is too long. I have several columns need to do so. I set the column property "Vertical Elasticity" to "Expand", they really expanded, but they covered the columns right beneath them.
I want them push the beneath columns next to them.

How could I do it?

Any help will be appreciated.

Thanks a lot!

 

[nagornyi]

Anchor outer frame of the beneath column to the expanding outer frame of the above column.

 

[roseMay]

Thanks a lot!

I realize it by adding a frame involving the upper columns, so they can expand in a same level.

Your idea is really helpful!

 

[roseMay]

I have another question.

I have four sections in every page, I need to put four records in every page, and one of the columns is very long, and the value is variable, if it's too long to fit in the section, it will go to next section, and put other records to the below sections, but the result is the left of the column goes to the next page, and push other records to the same page. The repeating frame is fixed on Horizontal and Vertical Elasticity. The frame outside the repeating frame is also fixed on Horizontal and Vertical Elasticity. The long column is fixed on Horizontal and expand on Vertical Elasticity.

I am a new developer in Oracle Reports. I tried everything to fix this , but I have no progress.

Any help will be appreciated.

Thanks a lot!!

 

[nagornyi]

Please give an example of what you are getting and what you want to get.

 

[roseMay]

Here is my report sample.

http://ca.pg.photos.yahoo.com/ph/rose_echo2002/detail?.dir=/c00d&.dnm=f928.jpg

http://ca.pg.photos.yahoo.com/ph/rose_echo2002/detail?.dir=/c00d&.dnm=1882.jpg&.src=ph

Thanks a lot!

 

[nagornyi]

Create 2 formul columns. The first one would return that part of the description field that fits into the section. The secone one would return the remaining part.
Now expand the repeatin frame to the size of two sections, and put two fields there, one above another. Those to be sourced with the first and second part of the description. The fields should have Fixed vertical elasticity. Make the vertical elasticity of the repeating frame Contract, so that it could shrink, but not expand. Then conditionally supres the ssecond field if it is empty.
A tricky part, of cource, is to separate the field into two. It may help if you use fixed size font, like Courier, so it would be possible to predict how many characters would fit into existing space.
This is not an easy solution for seems-to-be easy problem, but so far I can not think of anything else. Please come back with any further questions.

 

[roseMay]

Your idea is really helpful, I'll try it.

But in this report, there is some other difficult points, The upper columns will expand to two or three lines depending on the data, so I can not predict the height of the comment text.

 

[nagornyi]

Combine uppder column and description into the single field in your SQL, and then process them togeter while breaking into two.