Crystal Reports Campos strings

Technical Questions

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

Topic: Campos strings

Author	Message
ccouto Newbie Joined: 20 Jun 2012 Location: Brazil Online Status: Offline Posts: 23	Topic: Campos strings Posted: 28 Jun 2012 at 8:17am
	how do you attach strings? Example: I have two fields' Descrição1 "and" Descrição2 "wanted one completed the other on the same line. has the?
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Jun 2012 at 8:27am
	table.Descrição1 & table.Descrição2 or make a text field and drag and drop each field into it
	IP Logged

ccouto Newbie Joined: 20 Jun 2012 Location: Brazil Online Status: Offline Posts: 23	Posted: 28 Jun 2012 at 8:45am
	Exactly what I wanted.! "&" It allows to concatenate strings only 2 fields, or as needed?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Jun 2012 at 9:03am
	as many as you need you can also use + be aware that NULL values may stop the formula from evaluating. If so just change the formula field pick list option to 'use default values for nulls'
	IP Logged

ccouto Newbie Joined: 20 Jun 2012 Location: Brazil Online Status: Offline Posts: 23	Posted: 29 Jun 2012 at 3:12am
	How do that? I have 4 fields. "Description 1", "Description 2", "Description 3" and "Description 4". Since I want to join all be printed in the report and it happens that sometimes the Description field 3 has no content or any of them are empty.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Jun 2012 at 3:30am
	table.Descrição1 & table.Descrição2 & table.Descrição3 & table.Descrição4 Inside the formula editor there is a pick list option. on how to handle Null values. Set it to 'Use default values for Nulls'
	IP Logged

ccouto Newbie Joined: 20 Jun 2012 Location: Brazil Online Status: Offline Posts: 23	Posted: 29 Jun 2012 at 5:18am
	Thank you! Got it.!
	IP Logged

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