When one tries to open the Reports section of the Invoicing program, the report generator automatically accesses and displays the last report you had selected when you last closed out of the reports.
Crystal Reports Database Error - xbase error: db file position error
Is a result of the program attempting (and subsequently failing) to open the last report you had selected, which in the case of this error is always the Sales by Product report.
The Sales by Product report can sometimes overwhelm your system, especially if you have an extensive listing of Invoices in the Register, or many items in the Product Listing on the Product Tab. If you have a lot of data in either or both of these parts of the program (often through use over a long period of time), the Sales by Product report will have to process too much data for your PC to handle and the report generator will crash with the aforementioned error message.
To get back the rest of your reports, you must remove the Sales by Product report from your system. Here is how to do this:
- Close all open windows and programs running on your system.
- Click on the Start Menu and choose Find (for Windows 95/98) or Search (for Windows ME/2000/XP)
- When the Find/Search window opens, you want to search in here for Files or Folders on your C: drive
- Now type in *.RPT for what you want to search for, and start a search
- You should get multiple results for the search. In the listing, find and delete the file that says Sales by Product.rpt
- Now, change what you want to search for to *.RPF and start a second search
- You should get multiple results for the search again. In the listing, find and delete the file that says Sales by Product.rpf
- Close the Find/Search window and go back into your invoicing program.
- Click the View Menu and select Reports and your reports will open again
You will notice now that the Sales by Product report is no longer an option to choose. Ideally, you want to go without this report, as it will not run on your system with your extensive data. However, if you absolutely need to run this report, you must delete invoices and products from your database of information so that you have less information for the Sales by Product report to process. If you do this, you can then Restore the Sales by Product.rpt and Sales by Product.rpf files from your Recycle Bin to put them back in the proper Reports folder.