Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Brad Britton
  Where is Brad Britton?
 Alberta
 Canada
 Brad Britton
 To: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 Tags
Subject: RE: How do I supress printing on line?
Thread ID: 154982 Message ID: 155011 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Friday, December 21, 2007 5:50:44 PM         
   


> > I am trying to supress printing of a line when the value is equal to 0.00. I have placed an expression in the "print only when expression is true" box, under the "Print When" properties for that box. Here is that expression:
> >
> > Rpjpik.fqty_iss <> (0.00)

> >
> > I feel that this should work, but maybe I am missing something basic? Also, here is the expression for the box that prints, it is item quantity to pick for the job order.
> >
> > DisplayVal("N",iif(Rpjpik.fqty_iss>iif(Rpjpik.flextend,Rpjpik.ftotqty*Rpjpik.fquantity,Rpjpik.ftotqty),0,iif(Rpjpik.flextend,Rpjpik.ftotqty* Rpjpik.fquantity,Rpjpik.ftotqty)- Rpjpik.fqty_iss))
> >
> > Thanks in advance!
> >
> > Brad
> >
> >
> >
> >
>
> I don't know what's in your DisplayVal function, but that shouldn't matter. If you only want to print the field if Rpjpik.fqty_iss is not zero, then the expression in the Print When condition should work. You might try adding a textbox right next to this one that has Rpjpik.fqty_iss as its expression to see what the value of that field is.
>
>
> -BP
> www.peisch.com

Thanks for the info. I tried what you said, and the Rpjpik.fqty_iss holds a different number to what I would like to supress. What I cannot understand is how DisplayVal holds that data, but I cannot reference it for applying the "Print When" logic to it. I have attached a document related to the report I am having the issue with. The item in question is #19. If you had a moment to review it I would really appreciate it.

Report File Is Here - https://www.foxite.com/uploads/b57a815e-2ba8-4948-b61b-25d80e426b70.zip

Thanks,
Brad





ENTIRE THREAD

How do I supress printing on line? Posted by Brad Britton @ 12/21/2007 12:25:45 AM
RE: How do I supress printing on line? Posted by tushar @ 12/21/2007 3:49:31 AM
RE: How do I supress printing on line? Posted by Barbara Peisch @ 12/21/2007 3:57:03 AM
RE: How do I supress printing on line? Posted by Brad Britton @ 12/21/2007 5:50:44 PM
RE: How do I supress printing on line? Posted by Barbara Peisch @ 12/21/2007 9:37:23 PM