how to suppress first line and third line from a text in crystal report

Question

e.i

field=

abcdef
ghijkl
mnopqrs

result will be

ghijkl

abcdef = first line , ghijkl = second line, mnopqrs = third line — mohammed, Apr 02 '15 at 08:25

score 0 · Answer 1 · edited May 23 '17 at 12:06

0

There is suppress option you can give via conditionally on field. Check this links, or you can hide the line too.

suppress line conditional in crystal report

http://scn.sap.com/thread/3373009

http://asad-naeem.blogspot.in/2013/09/conditionally-suppress-line-or-box.html

https://martfish.wordpress.com/2012/03/31/crystal-reports-conditionally-supress-a-line-object/

edited May 23 '17 at 12:06

Community

1
1

answered Apr 02 '15 at 08:33

Ajay2707

5,690
6
40
58

any option to split this field as three based on lines – mohammed Apr 02 '15 at 09:31

score 0 · Answer 2 · answered Apr 02 '15 at 08:41

0

In the supress of the section write below:

if recordnumber =1 or recordnumber=3
then true
else false

answered Apr 02 '15 at 08:41

Siva

9,043
12
40
63

Thank you shiva. but this formula not solved issue. Because in my case there is no record number. only one field which is bind in report footer. type is string but there will be three or four lines in same field , i want to suppress first and third line only. – mohammed Apr 02 '15 at 08:53
any option to split this field as three based on lines – mohammed Apr 02 '15 at 09:30
how are you showing 3 lines in a single field? what is the formula? – Siva Apr 02 '15 at 09:48

score 0 · Answer 3 · answered Apr 02 '15 at 13:49

It'll depend on which white space character is separating the lines. This is usually ASCII character 10 (line feed) or 13 (carriage return). In any case you can use the split() function to get the line you want.

//Returns the second line of a carriage return-delimited text field
split({Table.MultiLineTextField},chr(13))[2]

Or, another example:

//Returns the third line of a line feed-delimited text field
split({Table.MultiLineTextField},chr(10))[3]

how to suppress first line and third line from a text in crystal report

3 Answers3