Ver.10 and Excel file

[sscarlott_(Guest)]

I am using version 10 to write a report that uses an Excel file as the master file. The only query I have in the report is that the type code = 3. There are 206 items with that code, but the report is only choosing 46 of them. Any ideas?

[kfleming]

Take out the filter and instead create a calculated field with the expression:__type code = 3____Place this field on a record band along with the type code field and see if it correctly shows as True and False.____Kathleen__R&R Support

[sscarlott_(Guest)]

I tried that but something else is wrong. With no query at all the report only generates 2197 items and there are 9504 in the Excel file. I have the file in a subdirectory by itself.

[kfleming]

Is your information on a record line? Are there any blank lines in the Excel file?____Kathleen__R&R Support

[sscarlott_(Guest)]

Yes, the information is on the record line. The Excel file does not contain any blank lines.____Thanks!

[kfleming]

If you want to send the file and report to me, I will have a look.____Kathleen__R&R Support__kfleming@livewarepub.com

[kfleming]

Your report has a joined table. If you select Database Joins Edit__you can click the Options button and then in the lower right, change the Included Unmatched Records radio button from the default choice of None to the bottom choice of Left. Then Ok this change and re-run the report. You will then see the missing records which are those that were not finding a match in the related table.____Kathleen__R&R Support