Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Doubts with formula in Crystal Reports XI Post Reply Post New Topic
Author Message
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Topic: Doubts with formula in Crystal Reports XI
     Posted: 11 Feb 2014 at 6:52am
good afternoon

I have a problem in crystal desenvolvir a report, most do not want the product type 40 does not show.

I created to formulate:

If not isnull({AGR_ENTRADA_CLASSIF_PAG_V.TIPO}) Then
   '40'
Else
   ({AGR_ENTRADA_CLASSIF_PAG_V.TIPO})
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 11 Feb 2014 at 7:48am
try this

If not (isnull({AGR_ENTRADA_CLASSIF_PAG_V.TIPO})) Then
   '40'
Else
   ({AGR_ENTRADA_CLASSIF_PAG_V.TIPO})
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 11 Feb 2014 at 8:39am
hello

formnula used the products of the type '40 'even appears. the type '40 'does not show in the report.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Feb 2014 at 10:06am
The way you have it written is basically just going to result in either a '40' or a null. I think you want it to show 40 when it is null?
 
If isnull({AGR_ENTRADA_CLASSIF_PAG_V.TIPO}) Then
   '40'
Else
   {AGR_ENTRADA_CLASSIF_PAG_V.TIPO}
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 12 Feb 2014 at 2:16am
even if it is null is not for show. is to do this procedure.
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 12 Feb 2014 at 8:10am
Hello
good afternoon

have another formula that can be applied to solve this problem.

grateful. who help.
IP 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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.