How to handle no data

  • Thread starter Thread starter Three
  • Start date Start date
T

Three

How do I set a default value or hide a calculated totals field at the end of
a report when no data is returned by the datasource?

I'd like to set either the totals fields to zero (currently shows error) or
otherwise hide them.

Cheers
 
Reports have a no data event. In that event, you could either change
(temporarily) the source of the controls OR hide the controls by setting their
visible property to false.

If you need help writing the necessary code then post back.
 
You must log in or register to reply here.

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

Display/hide totals 3
# Error when no data 4
Reports, Sub-reports running sum and no data 2
Calculated Report 3
Access how do you set a yes/no data type as required? 0
Record omission 2
Crosstab report - handling Null fields 4
Include totals in footers to fields in layout collection (2007) 1

Back
Top