Report/Crosstab Question

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

I am trying to find a way to prevent lines on the report
from printing if the total is = 0. The report is based on
a cross_tab query. When I try to limit the query
to "balances" <>0 in the criteria, I get and aggregate
function error.

Can I write an expression in the report that will not
print lines that have a 0 only result?

Hope this is enough info.

Thanks,

Ted
 
One way: In the Detail_Format event you can check the current record and set
Detail.Visible to True/False accordingly.

You also need to make sure that the Detail section (and all the controls
within it?) have their CanShrink properties set to Yes, unless you want
"Invisible" detail to show up as blank lines.
 
Back
Top