Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report Footer Indicator? Post Reply Post New Topic
Author Message
kenif
Newbie
Newbie
Avatar

Joined: 19 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Quote kenif Replybullet Topic: Report Footer Indicator?
    Posted: 19 Mar 2009 at 9:48am
Hello.
I need to modify an existing report to include a summary/footer text box that indicates the presence of a specific value in the data.
 
ie: if 'Bob' is in the recordset of first_names, then have a single line on the report that reads 'Bobs in the list'.
 
I am a programmer by profession but this is my first task with Crystal Reports.
 
Thanks for any attention to my question.
 
Ken
 
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Mar 2009 at 10:26am

Here is one way:

First formula as "FindBob":
If {table.field}= "Bob" then 1 else 0
 
Second formula for text as "BobText":
if 0">Sum{@FindBob}>0 then "Bobs in the list"
 


Edited by DBlank - 19 Mar 2009 at 10:27am
IP IP Logged
kenif
Newbie
Newbie
Avatar

Joined: 19 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Quote kenif Replybullet Posted: 19 Mar 2009 at 11:21am

Thank you DBlank.  I think the syntax of your example got screwed up, but you sent me in the right direction and the report is working well.

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Mar 2009 at 12:05pm
Oops. Dreaded copy and paste error. Embarrassed
Sorry about that but glad you could decipher it Thumbs%20Up
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.