Report has no data to display - but it should have

Question

I have a parameter driven report that has two group footers (which display sub-totals). The group footers get supressed if the appropriate parameter is set. For instance, I don't want a sub-total per day if the report covers only one day.

What is happening is when I have the parameters set to display all the records, I can see certain records on the report. When I change the parameters to show only particular records (and thus supressing the footers), I get 'report contains no data' even though based on the SELECT and WHERE clauses there should be data.

What exactly does the report generator check to determine if a report has no data?

Answer 1

I have a parameter driven report that has two group footers (which display sub-totals). The group footers get supressed if the appropriate parameter is set. For instance, I don't want a sub-total per day if the report covers only one day

How are you accomplishing the 'suppression?'

Is it in the report or in the record source of the report?

---

Build a little, test a little

Answer 2

Ok I solved this one, it turned out that in certain circumstances my WHERE clause was comparing on the wrong column name.

The group footer suppression is accomplished by setting the visible property to false in the report open event.