CODEWITHSUNDEEP
crystal-reports
Poke Mon
Poke Mon

Reputation: 1

In Crystal Report line break when used commas

I have 3 fields: {Marks1},{Marks2},{Marks3}. I want to line break when commas show.

Marks No.1 data ( ORD00215855_01,ITEM NO. 293921,TC ID T066725,) Marks No.2 data (c,ITEM NO. 293922,TC ID T066727,) Marks No.3 data (ORD00214587_01,ITEM NO. 264876,TC ID T080812,)

like show: 

ORD00215855_01
ITEM NO. 293921
TC ID T066725
TC ID T066725
TC ID T066727
ORD00214587_01
ITEM NO. 264876
TC ID T080812

Please help me.

Upvotes: 0

Views: 1145

Answers (1)

MilletSoftware
MilletSoftware

Reputation: 4001

Use 

Replace({Table.MARKSNO1},",",Chr(10) + Chr(13))

to replace the comma.

Upvotes: 3

Related Questions