To make it clearer, I pasted the screen shots in to here.
I have several fields in my subreport..
I right clicked on the "Misc.DocMiscAmt" (It is the sum of the Misc charge) and put the currentfieldvalue=0
This is where I put this in the main report...
In Report Footer a section expert..Ticked the "Suppress Blank Section" and typed in "TRUE".
If there's a Misc charge, this is how it looks like when I preview the subreport....
After putting the formula, the info disappears but not the section..Don't know where I did wrong??? :(
UPDATE:
Problem solved! Thanks DB!

Edited by khyulitz10 - 03 Oct 2011 at 11:38pm