1) Set RV99 to the value 1 (true).
2) Cycle through all the child record using the sub-report
function and this instruction for Store Value in Report Variable
for RV99:
IF P7F1 = "Floor Care" THEN 0 ELSE RV99 endif
3) In the first line following the sub-report use the "Skip
Record if RV is False" function:
Skip Record if 0 (False) Is in Report Variable 99
This will skip records with a child record containing
"Floor Care" regardless of how many other child records
are present or where the "Floor Care" record is in sequence.
Hope this helps. Feel free to give me a call if you're having
difficulties.
Pat
505-797-9072
At 09:52 AM 9/18/2007, you wrote:
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
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
