hi all,
i have made a WITH HOLDING TAX REPORT in which there is field of TAX RATE , TAX AMOUNT(which is i am displaying twice in report).But the requirement is that if my Report is showing TAX RATE valueis 0 than the field TAX AMOUNT should also display 0.But when i execute my Report it shows me TAX AMOUNT which have some amount after all it has no TAX RATE.
for example:
BASE AMOUNT TAX RATE TAX AMOUNT TAX AMOUNT
100,000 5 5000 5000
110,000 * 0* 3300 3300
you can see that in the second record there is no rate but tax amount is showing.The Tax Amount should be 0.
can anybody do some needful.