Thursday, September 11, 2008

How to handle Overlapping of Large Text Fields in Crystal Reports

Level: Intermediate

Knowledge Required:
Crystal Reports

Description:
While working in Crystal Reports, we sometimes face a scenario when we need to put a Large Text Field (which can grow upto multiple lines). The issue comes if we try to put another Field after this Text Field. Example:


As you can see in above I have put to Formula Fields, both will contain Large Text which may expand. So here is the preview,


Therefore to solve this issue we can create multiple sub-sections in the same section. This can be achieved by Section Expert.


Now we will put the Fields in different sub-sections as,


And here is the preview again,



Note that in Crystal Reports Sections automatically expand, that is why when the first Text Field expands, the section also expands itself, therefore ultimately the next field renders properly.

10 comments:

Eler.........Oce said...

Thanks buddy...Nice post.
Helped a lot.

Mahesh said...

Rally Wonderful
Problem Solve

Anonymous said...

works fine

Anonymous said...

Thanks A Lot, It helped me very well

Unknown said...

Thank alot
Helped me alot

Pravin Prajapati said...

nice post thank you

Anonymous said...

Thanks for the post...

Anonymous said...

Just saved my day! Thank you :)

Imi Comp said...

How 'bout if the overlapping texts is in the Section Detail area?
You cannot make Detail for each record, or can you?

Arsalan Tamiz said...

@Imi Comp: The same technique applies on Detail Section as well. You can add sub-sections in Detail Section also.