selection criteria in report

[scamper]

Since I am new to working with access 2007 reports but I have reporting expereince using sql server 2008 r2 reporting service, I have the following question to ask.

When I run the sql alone that is behind an access 2007 report, I get x-number of rows selected. However when I run the actual access 2007 report, I am missing about 10% of the rows that appeared when I just ran the sql that is behind the access 2007 report.

Thus can there some some selection criteria embedded in the access report that restricts some rows from appearing on the report? If so, can you tell me what to check in a report to see where this extra selection criteria can be at?

 

[vbaInet]

The Filter property of the report will be a good start. Can you see a pattern of the missing results?

 

[scamper]

How do I find the filter property of the report?

Is there a tutorial you recommend that I look at to learn how a selection criteria can be setup in an access report?

The pattern I noticed is the larger the date range of records that I am selecting, the higher percentage of records that are missing.

 

[vbaInet]

That's interesting. The Filter property is found in the Property Sheet (under the Data tab) of the report. Open the report in Design View, right-click anywhere in the report (i.e. anywhere apart from the controls), and select Properties.

Now since you don't know where the Property Sheet is then you can't be sure that the Record Source of the report is not the culprit. So when you open the Property Sheet (on the same Data tab) look for the Record Source property and that will show you what it's bound to.