Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: multiple entry, ignore customer Post Reply Post New Topic
Author Message
drawde5
Newbie
Newbie


Joined: 10 Sep 2013
Online Status: Offline
Posts: 2
Quote drawde5 Replybullet Topic: multiple entry, ignore customer
    Posted: 11 Sep 2013 at 11:19am
Need some direction and syntax. Preemptive thanks for your advice. I can use select expert to get all customers of a specific types, but how would I exclude if customer is any other type?

cust, type#
Ed, 1
John, 2
Ed, 3
Bert, 2
John, 99

Most of the time a customer will have many different types.
Very rarely will a customer have just one or two types

Im trying to create a report which displays customer with a specified type#(s), kicker is, if customer has any other type, I don't want to display customer at all.

Ex. I want only customer type 1 and 2 but if they are also customer type 3, 4, 5,...,99 I don't want to see them. *Table above should only show Bert.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Sep 2013 at 11:41am
if you want a crystal only solution you group on the customer and flag the values rows you want and do group select statements
 
or you use stored procs with exists or not exists clauses or inner queries (or a crystal command could do this as well)


Edited by DBlank - 11 Sep 2013 at 11:42am
IP IP Logged
drawde5
Newbie
Newbie


Joined: 10 Sep 2013
Online Status: Offline
Posts: 2
Quote drawde5 Replybullet Posted: 11 Sep 2013 at 1:35pm
Thank you for your insights, will try.
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.