Patrick,
Thanks!
I do use the "Skip Record . . . " to choose the records I am looking
for. Starting from the main panel, I create a subreport through a
panel link; in the Report Body, RV 1 contains a series of "or"
statements like this:
contains [P7F1; "Car Care"] or
contains [P7F1; "Disinfectants"] or
and so on.
Then, RV1 =0
Then, Stop [Sub]Report if 0 is in Report Variable 10
I exit Subreport (back to main panel)
Then, Skip Record if 0 (False) Is in Report Variable 1
Then I reset RVs 1 & 10.
That all works perfectly.
But, I want to skip a record where P7F1 (from RV1) would be "Floor
Care," regardless of whether the other categories are true. Can I do
that with a "not" phrase in the same RV? Or, would I have to do
"double dip" and repeat the subreport on the same child panel by first
looking for the category I don't want, excluding its parent record, and
then continue looking for the category I do want if that record wasn't
excluded?
Charlie
Patrick Riley wrote:
Charles, I'd suggest using the "Skip Record if RV is
False"
under
the "Iteration Control" function on the [Ctrl]+[F7] menu.
Two lines of code should do it:
IF field = "E" then RV99 = 0 ELSE 1 ENDIF
Then under the above option:
Skip Record if 0 (False) Is in Report Variable 99
Good luck.
Pat Riley
At 08:45 AM 9/18/2007, you wrote:
Hi
Everybody,
I'm sure the answer to this question is simple, but I'm just not sure
how
to go about it.
My customer database has the name and address on the main panel.
One of the child panels has a list of mailing mailing list categories
each customer is assigned to. For the purpose of this question,
I'll call those mailing list categories, A, B, C, and so on.
I have a report, using stop/skip within a subreport to select customers
if they belong to any of a number of mailing list categores, and it
works
well. But what if I want to exclude someone if they belong a
certain category, even through the other categories would warrent
inculsion?
In other words, I want to include customers in categories, A, B, C,
D, F, and G. But if they are also in category E, I want them
excluded from this mailing.
Tips are appreciated!
Thanks.
Charlie Wolf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
|
