> >
> >
> >
> > 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