Crystal Reports Part of field visable

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Part of field visable

Post Reply

Post New Topic

Author	Message
Wosp Groupie Joined: 05 Sep 2012 Location: Sweden Online Status: Offline Posts: 45	Topic: Part of field visable Posted: 01 Jul 2014 at 1:12am
	Hi! I got a report that shows different objects in a list, one of the fields shows a group ex. enviroment, maintenence or cars. but on the reports in that field it shows \enviroment\ \maintenence\ \cars\ i dont want it to show the backslash \ how do i suppress/hide only the \
	IP Logged


Gurbs Senior Member Joined: 16 Feb 2012 Location: Ireland Online Status: Offline Posts: 216	Posted: 01 Jul 2014 at 3:01am
	do you want to suppress all the \? In that case you can create a formula replace({table.field},'\','') This is replacing the '\' with nothing, so it is removing them Otherwise if you always want to remove the first and last character, write a formula like mid({table.field},2,(lenght({table.field})-2) Edited by Gurbs - 01 Jul 2014 at 3:04am
	IP Logged

Wosp Groupie Joined: 05 Sep 2012 Location: Sweden Online Status: Offline Posts: 45	Posted: 01 Jul 2014 at 7:59pm
	Thanks for reply! Its the first one i want replace({table.field},'\','') I put it in Selection formulas > Record and get this error message: "The result of selection formula must be a boolean"
	IP Logged

Gurbs Senior Member Joined: 16 Feb 2012 Location: Ireland Online Status: Offline Posts: 216	Posted: 01 Jul 2014 at 9:06pm
	No, you should create a formula in your field explorer. After that, place the formula on your report where you want to show the object. The record select is like the where clause in SQL. If data doesn't meet that criteria it isn't loaded into the report.
	IP Logged

Wosp Groupie Joined: 05 Sep 2012 Location: Sweden Online Status: Offline Posts: 45	Posted: 01 Jul 2014 at 9:42pm
	I figured something out , if i use my brain and do as you said it works =o) Big Thanks...
	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