Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How to divide a field that contains text? Post Reply Post New Topic
Author Message
denhors
Newbie
Newbie
Avatar

Joined: 04 Jan 2011
Online Status: Offline
Posts: 20
Quote denhors Replybullet Topic: How to divide a field that contains text?
     Posted: 17 Jan 2011 at 3:09am
How do I share a dynamic field that contains text from the database in more details?
The report has multiple pages, each page of the report contains new details. I wish that after you fill the Details A, the rest of the text printed on a new page in the Details B, and so on.
PH
 GH
  Da - page 1
  Db - page 2
  Dc - page 3
  :
  :
 GF
PF
Thx
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Jan 2011 at 3:56am

I think you are asking can you split one large text field into multiple fields. Then place each of these multiple fields onto distinct detail sections and then make each detail section be on a new page. Is that correct?

You can use formulas to select sections of the field you want top break up like:
left(field,length)
mid(field,start,length)
right(field,length)
Place each on there own detail section
in the section expert make each detail section use New Page Before (or after)


Edited by DBlank - 18 Jan 2011 at 3:57am
IP IP Logged
denhors
Newbie
Newbie
Avatar

Joined: 04 Jan 2011
Online Status: Offline
Posts: 20
Quote denhors Replybullet Posted: 25 Jan 2011 at 1:46am
Well you understood my problem, but do exist command to split a field by lines.
Thank you for your response.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Jan 2011 at 4:01am
NOt quite sure I understand your second question. I gave you some options for how to break it up into 3 sections ...
left(field,length)
mid(field,start,length)
right(field,length)
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum