Crystal Reports Boolean Translation

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

Topic: Boolean Translation

Author	Message
josh2009 Newbie Joined: 26 Jun 2009 Location: United States Online Status: Offline Posts: 16	Topic: Boolean Translation Posted: 25 Aug 2009 at 6:19am
	I am using Crystal Reports 8.5. Given a boolean value of 1 or 0 in a SQL database table column, how can I translate the value in the report to say if 1 = 'Successful' or 0 = 'Failure'? Any help will be greatly appreciated. Thanks
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 25 Aug 2009 at 7:22am
	Create a formula field as "BooloeanText" (or whatever you want): *if {table.booleanfield}=1 Then 'Successful' else 'Failure'*
	IP Logged

josh2009 Newbie Joined: 26 Jun 2009 Location: United States Online Status: Offline Posts: 16	Posted: 25 Aug 2009 at 11:33am
	Thank you. That's exactly what I did. I appreciate it.
	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.000 seconds.