Page 1 of 1
Ver.10 and Excel file
Posted: Thu Apr 24, 2003 12:57 pm
by 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?
=> RE: Ver.10 and Excel file
Posted: Thu Apr 24, 2003 3:06 pm
by 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
==> RE: Ver.10 and Excel file
Posted: Thu Apr 24, 2003 3:50 pm
by 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.
===> RE: Ver.10 and Excel file
Posted: Fri Apr 25, 2003 6:34 am
by kfleming
Is your information on a record line? Are there any blank lines in the Excel file?____Kathleen__R&R Support
====> RE: Ver.10 and Excel file
Posted: Fri Apr 25, 2003 12:31 pm
by sscarlott_(Guest)
Yes, the information is on the record line. The Excel file does not contain any blank lines.____Thanks!
=====> RE: Ver.10 and Excel file
Posted: Fri Apr 25, 2003 7:59 pm
by kfleming
If you want to send the file and report to me, I will have a look.____Kathleen__R&R Support__kfleming@livewarepub.com
======> RE: Ver.10 and Excel file
Posted: Mon Apr 28, 2003 5:20 pm
by 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