Formatting a lable so it dynamically expands to other labels if needed

[RPOC]

i am using crystal 11. I created a label that has a variety of fields on it. The label will have a notes area and the notes can range from 1 character to a couple of hundred. Since the notes are a variable, Is there a way to make the extra data show up on additional labels if needed.

 

[lbass]

A label really contains only one row of data, so you can't force a new label unless you can create a second row. You could potentially use a command that uses a union statement as your datasource. You would add the notes up to a certain length in the first component of the union statement and then add additional unions for each additional length, e.g., the first row could contain left({table.field},100), and the second one could contain mid({table.field},101,100), the third could contain mid({table.field,201,100), but you would be duplicating rows where the length extended beyond 100. I'm not sure of the function you can use in a command that works like "mid"--possibly locate().

-LB