Crystal Reports Concatenating string output?

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Concatenating string output?

Author	Message
Maahes Newbie Joined: 26 Sep 2008 Location: United States Online Status: Offline Posts: 8	Topic: Concatenating string output? Posted: 07 Oct 2008 at 4:34pm
	Specifically what I'm wanting to do, is I have a table which stores Social Security numbers as a string. I want to tell it to omit outputting all but the last 4 characters. How might I go about doing that in CR 9?
	IP Logged

Savan Senior Member Joined: 14 Dec 2007 Location: India Online Status: Offline Posts: 162	Posted: 08 Oct 2008 at 2:57am
	create a formula which has following syntax mid(<field>,1,length(<field>)-4)
	Thanks Savan
	IP Logged

Maahes Newbie Joined: 26 Sep 2008 Location: United States Online Status: Offline Posts: 8	Posted: 08 Oct 2008 at 10:22am
	Errr.....slightly wrong syntax, That gives me ###-## rather than #### Edit: Nevermind, figured it out Edited by Maahes - 08 Oct 2008 at 11:23am
	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.031 seconds.