Crystal Reports Record Selection

Report Design

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

Topic: Record Selection

Post Reply

Post New Topic

Author	Message
sandia69 Newbie Joined: 15 Apr 2011 Online Status: Offline Posts: 2	Topic: Record Selection Posted: 15 Apr 2011 at 6:17am
	I have a helpdesk ticket. The ticket has multiple assignments to differrent teams. If anyone of those assignments has been made to Team X - do not select that ticket for the report. I am having a problems figuring out the code to bypass those records that have an assignment to Team X. I am using Crystal 11. Thanks all..
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 15 Apr 2011 at 6:39am
	if you do not want to do this in your source type (stored proc, view, command, etc.) then you can do this through group selection if you group on the ticket make a formula to 'flag team x' rows as if table.assignedteam = 'team x' then 1 else 0 SUM this at the ticket group level SUM(@flag,ticket) now any ticket that had team x assigned will have a value > 0 use that in the group select statement SUM(@flag,ticket)=0
	IP Logged

sandia69 Newbie Joined: 15 Apr 2011 Online Status: Offline Posts: 2	Posted: 15 Apr 2011 at 7:34am
	Thanks...I will give that a shot !!!!
	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