Report:
Body
RV = Rv+1
SubReport:
Body
Rv1 cases
RV1 =1 and list doesn't contain A then 0 else 1
RV1=2 and list doesn't contain B then 0 else 1
RV1=3 and list doesn't contain C then 0 else 1
etc.
Skip record if 0.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
However, the easiest way to do this is probably just print out with delimiters
Name, Address, CATEGORY - and then use a spread sheet to sort them on category.
Date: Sun, 5 Apr 2009 00:18:26 -0400
From: [email protected]
To: [email protected]
Subject: [Dataperf] Perplexed!
Hi Everybody,
I'm getting a headache trying to figure this out. It may just be the way DP
works, but this is what I need to do.
The company I do business with has come up with three catalogs for three
separate product groups --- call them catalogs "A," "B," and "C." My customer
database has a parent record (name, address) and a child record (mailing list
categories) containing one or more various categories which correspond to the
product groups. I want to create seven different lists of the following groups.
A
B
C
AB
AC
BC
A, B, and C.
I've done reports for years extracting names based on specific categories with
subreports using Stop-Skip, but I can't figure how to do this.
First I tried listing all the "A" categories (using "contains") grouping them
with parenthesis, then the "Bs," then the "Cs" and using "or" between the
groups within one RV. I then tested to see if the RV was true, but it's always
false. (Yes, there customers that fit the model. I then tried moving the
categories to three separate RVs, and then testing that RV with "and"
statements to see if all three were true. Still no results.
I haven't even tried to work out the formula for "A and B, but not C," etc. If
I couldn't get the one for A, B, and C, I figured, what's the use!
Could someone please guide me as to an approach that would work?
Thanks!
Charlie Wolf
_________________________________________________________________
Rediscover Hotmail®: Now available on your iPhone or BlackBerry
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Mobile1_042009_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
