Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: if than else formula Post Reply Post New Topic
Author Message
MedanekTom
Newbie
Newbie
Avatar

Joined: 31 Jul 2012
Location: Czech Republic
Online Status: Offline
Posts: 2
Quote MedanekTom Replybullet Topic: if than else formula
    Posted: 01 Aug 2012 at 12:58am
Dear all,

I´m working ond report, which is using connection to MS SQL srv.

Now, i need to make a formula

I made this, but it doesn´t work. Could I ask for help to resolve this?

if ({CARRIER_GROUP_DETAIL.CARRIER_GROUP}="ONE")
then ({CARRIER.CARRIER}={CARRIER.CARRIER})
else ({CARRIER.CARRIER}="LOGISTICSCOMPANY")

Thank you for any help
Tom
IT admin, MOL Logistics (czech) s.r.o.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 01 Aug 2012 at 5:10am
How doesn't it work?  What are you trying to do and where are you using the formula?  Which version of Crystal are you using?
 
-Dell
IP IP Logged
MedanekTom
Newbie
Newbie
Avatar

Joined: 31 Jul 2012
Location: Czech Republic
Online Status: Offline
Posts: 2
Quote MedanekTom Replybullet Posted: 01 Aug 2012 at 8:38pm
Hi,

I have CR 2008
I´d like to check one table, where are lot of carriers and there are two tipes of carriers. Fo example england and german.

I´d like to put into the report information from another table.

I tried to make a formula for it.

So it means.
----------------------
If in first table carrier is england, take from second table his name

If in first table carrier is german, take "one specified" carrier name.
-------------------
Excuse me, if it is not understandable. Let me know, if I can explain something more.

Tom
IT admin, MOL Logistics (czech) s.r.o.
IP IP Logged
barkin
Newbie
Newbie


Joined: 24 Jul 2012
Online Status: Offline
Posts: 4
Quote barkin Replybullet Posted: 02 Aug 2012 at 1:21am
Originally posted by MedanekTom



if ({CARRIER_GROUP_DETAIL.CARRIER_GROUP}="ONE")
then ({CARRIER.CARRIER}={CARRIER.CARRIER})
else ({CARRIER.CARRIER}="LOGISTICSCOMPANY")

Tom
 
Basic
 
if ({CARRIER_GROUP_DETAIL.CARRIER_GROUP}="ONE") then
{CARRIER.CARRIER}
else
"LOGISTICSCOMPANY"
 
Save and use in the report


Edited by barkin - 02 Aug 2012 at 1:21am
IP 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.016 seconds.