Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Details section(s) fixed. How to get extra data in next section??

Status
Not open for further replies.

MAT2001

Technical User
Feb 22, 2001
20
CA
Have a form that must have the details area an exact size. There are instances where data from a field will not fit into the box, so need it to have remander go into the next detailed section area. Using Crystal 8.5 and have figured out the VB script to determine if data will fit and if not what amount needs to be moved down to next section. Do not have any idea of the VB formula/code needed to tell it to print in the next detail section.

Any help would be greatly appreciated. :)
 
Assuming you have a formula called "Overflow"
that holds the overflow text, and that you want
to use it in the detail area of the NEXT record,
you could use the Previous(fld) function to create
a fomula that retuns Previous({overflow}).

hth,
- Ido
 
Now you have totally lost me. No currently my formula is developed to drop the data to the next line of same record and to grow accordingly. Will have to look at this. Very frustrating process. Thanks for your comments. :-(
 
If you simply need the next line in the SAME record,
then create another detail section, place the overflow
in it, and suppress it if the overflow is empty.

hth,
- Ido
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top