Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: sanjay karia
  Where is sanjay karia?
 mumbai
 India
 sanjay karia
 Tags
Subject: RE: remove line if blank
Thread ID: 172627 Message ID: 172666 # Views: 20 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Friday, May 09, 2008 2:10:13 PM         
   


> >
> >
> >
> > I am confused? I can't see freight charges in the example above, please refer to one item above such as cess_amt or tax_amt.
>
>
>
> even i am confused? the attachment which I sent u was without freight charges, which is after tax amount. I am trying to solve this for last 2 days, but can not locate the problem


Anyway, if your problem is about the boxes, you must not create a single box, you must create several boxes as follows:

1. from top of discount up to between disc_amt and excise amount
2. another from top of discount up to between excise and cess_amt
3. another from top of discount up to between cess_amt and hcess_amt
4. another from top of discount up to between hcess_amt and tax_amt
5. last, from top of discount up to after tax_amt

Then you must find a way to put those fields in summary band be counted prior to calling your report before REPORT FORM command like:

m.Disc = iif(disc_amt = 0, 0, 1)
m.excise = iif(excise = 0, 0, 1)
m.cess = iif(cess_amt = 0, 0, 1)
m.hcess = iif(hcess_amt = 0, 0, 1)
m.tax = iif(tax_amt = 0, 0, 1)

Then sum all so that you will know how many have values of 1:

m.WithValue = m.Disc + m.excise + m.cess + m.hcess + m.tax


Now use the result in your boxes:

On your first box: float, remove line if blank, print when m.WithValue = 1
On your 2nd box: float, remove line if blank, print when m.WithValue = 2
... and so on

Haven't tested it yet though, but I think it would work

I will try to recreate it for you and will return to you later.. :-)

Jun



COMPLETE THREAD
remove line if blank Posted by sanjay karia @ 5/9/2008 11:04:20 AM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 11:24:05 AM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 12:03:28 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 12:10:39 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 12:26:31 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 12:36:29 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 12:57:35 PM
RE: remove line if blank Posted by surinder singh @ 5/9/2008 1:03:47 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 1:10:47 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 1:14:36 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 1:18:46 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 1:17:11 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 1:32:21 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 1:41:25 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 1:55:21 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 2:02:33 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 2:10:13 PM
RE: remove line if blank Posted by surinder singh @ 5/9/2008 2:10:58 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 2:20:54 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 2:24:06 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 2:33:11 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 2:39:22 PM
RE: remove line if blank Posted by sanjay karia @ 5/9/2008 2:45:19 PM
RE: remove line if blank Posted by Glenn Villar @ 5/9/2008 2:48:40 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 2:52:50 PM
RE: remove line if blank Posted by Barbara Peisch @ 5/9/2008 10:14:50 PM
RE: remove line if blank Posted by Jun Tangunan @ 5/9/2008 11:02:29 PM