Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Help in the selection logic Post Reply Post New Topic
Author Message
203bravo
Newbie
Newbie


Joined: 21 Dec 2010
Location: United States
Online Status: Offline
Posts: 3
Quote 203bravo Replybullet Topic: Help in the selection logic
    Posted: 21 Dec 2010 at 11:01am
currently using CR XI... grouping records based on invoice number then showing a comment field and date field.  there is a new comment created each time something is altered to the invoice.
 
trying to create a quick report to show only invoics that have no payment activity.  thus i am attempting to search the comments for "*payment received" to flag it.
 
example
 
35130
   2010-12-15     payment recieved
35132
    2010-12-15    shipment confirmed
    2010-12-19    shipment received
35133
    2010-12-01    shipment received
    2010-12-15    payment received
 
 
so i would only want to return invoice 35132.  I have to thought to flag it by at each entry and if the flag is false and payment received then set the flag to true.  this works, but i cannot select on the flag because of the formula. (it does not even show up as a possiblity in the select expert)
 
any all suggestions or help is appreicated.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Dec 2010 at 11:26am

create a fomula called @Flag

instring(table.commentfield,'payment received',1)
SUM this at the group level of invoice number
SUM(@Flag,table.invoicenumber)
go into the select expert and flip it to group select option and add your criteria there
SUM(@Flag,table.invoicenumber)=0 (Set this formula to use default values for NULLs)
 


Edited by DBlank - 21 Dec 2010 at 11:27am
IP IP Logged
203bravo
Newbie
Newbie


Joined: 21 Dec 2010
Location: United States
Online Status: Offline
Posts: 3
Quote 203bravo Replybullet Posted: 21 Dec 2010 at 11:52am
THANK YOU ---- basically the same process i was using just didn't do the group selection.  works like a dream.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Dec 2010 at 11:58am
no problem.
just a warning that group selection happens after many calculations occur so you have to make sure any summaries you are doing are account for this and the excluded groups still appear in the group tree, just not the body of the report
IP IP Logged
203bravo
Newbie
Newbie


Joined: 21 Dec 2010
Location: United States
Online Status: Offline
Posts: 3
Quote 203bravo Replybullet Posted: 22 Dec 2010 at 5:12am
Thank you for the warning - i did have a minor correction to make on that as well.
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.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.