Re: Excluding a record

Charlie, I'd handle it like this:

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
> > > Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> > > http://lists.dataperfect.nl/mailman/listinfo/dataperf
> >
> >
> >
> > _______________________________________________
> > Dataperf mailing list
> > Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> > http://lists.dataperfect.nl/mailman/listinfo/dataperf
> >  
> _______________________________________________
> Dataperf mailing list
> Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> http://lists.dataperfect.nl/mailman/listinfo/dataperf



_______________________________________________
Dataperf mailing list
Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
http://lists.dataperfect.nl/mailman/listinfo/dataperf