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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross_tab & Report Help 3
Help with a report 2
Access Access Report Works on One Machine but not Another 3
Reports 1
Excel Need Countifs Formula Help 0
Sub report based on Crosstab query 4
Microsoft Access Dynamic reports 1
Filter reports 1

Back
Top