Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Split Memo field Post Reply Post New Topic
Author Message
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Topic: Split Memo field
    Posted: 17 Feb 2016 at 12:44am
Hi,

I have a table which contains Memo field type, because the user need to type many lines information.

My issue:
When the User print the report, this info field will printed continuing to next page without break.
So, it's not correct.

How to split this memo field when it comes / reach some lines and continue to next page?


Thanks in advance.

Note:
I am using CR XI.

Emir W
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 17 Feb 2016 at 5:06am
Short of creating formulas that split the memo field up either by the number of characters or a number of lines (looking for a number of chr(13)'s).  Either way could be rather messy.
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 17 Feb 2016 at 5:57pm
I have created 2 formulas to check how many characters and how many lines for the Memo. And plan to split it in two parts.

But confuse with how to print those 2 parts? By using Section Expert?

Edited by Emir_W - 18 Feb 2016 at 12:17am
Emir W
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 18 Feb 2016 at 4:23am
I would put each formula in a section.  That way you could suppress the section if the memo if it was not that long.  Also you would not need to worry about the formulas overlapping.
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 21 Feb 2016 at 3:04am
Thanks a lot, Kevlray. It's solved now.
Just playing with sections and variables.

Case close.
Emir W
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.000 seconds.