Sandy,
You state you have the program as: "One to conditionally print if there is
no purchase point and one to print if
there is". If this is what you have in it, it sounds like your are telling
the program to print both. Your first statement is saying print when PP =
NO, and your second statement is saying print when PP = YES. I think if you
change both to print when YES or both to print when NO, your report will
work as you want it to. It can't hurt to try it.
Sandy Zarda
Major Industries Inc
________________________________________________________________________
________________________________________________________________________
Message: 4
Date: Tue, 26 Aug 2003 16:25:54 -0500
From: "Sandy Morse" <smorse@...>
Subject: Report Builder Question
I need to build a report on approved vendors and print the vendor master
name and address if there is no purchase point. If there is a purchase
point I want to print only the information from the VendorPP file and I do
not want to print the Vendor Master information. I have the report set up
with a left join to the VendorPP from the Vendor file and two detail lines.
One to conditionally print if there is no purchase point and one to print if
there is. I am getting both lines every time. What do I need to do?
Thanks!
Sandy Morse
BVR Technologies Company
________________________________________________________________________
________________________________________________________________________
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
You state you have the program as: "One to conditionally print if there is
no purchase point and one to print if
there is". If this is what you have in it, it sounds like your are telling
the program to print both. Your first statement is saying print when PP =
NO, and your second statement is saying print when PP = YES. I think if you
change both to print when YES or both to print when NO, your report will
work as you want it to. It can't hurt to try it.
Sandy Zarda
Major Industries Inc
________________________________________________________________________
________________________________________________________________________
Message: 4
Date: Tue, 26 Aug 2003 16:25:54 -0500
From: "Sandy Morse" <smorse@...>
Subject: Report Builder Question
I need to build a report on approved vendors and print the vendor master
name and address if there is no purchase point. If there is a purchase
point I want to print only the information from the VendorPP file and I do
not want to print the Vendor Master information. I have the report set up
with a left join to the VendorPP from the Vendor file and two detail lines.
One to conditionally print if there is no purchase point and one to print if
there is. I am getting both lines every time. What do I need to do?
Thanks!
Sandy Morse
BVR Technologies Company
________________________________________________________________________
________________________________________________________________________
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/