Error Printing Crystal Reports - Btrieve Data Buffer Length Error

Fields have been added to the ACCPAC database by UniSalesAnalysis.  Although the ACCPAC architecture will allow this, Crystal Reports will report this as an error when printing certain reports.

UniDevCo have modified these reports to comply with the changes in the database and the modified reports are available by contacting info@unidevco.com  Please advise if you are using a multicurrency database when requesting modified reports.

To resolve this error:

For each report, follow this procedure.

  1. Open the report in Crystal. Be sure to save a backup of the original report prior to proceeding.
  2. Chose Edit - Subreport Links to find all subreports linked to the main report. List all subreports.
  3. Return to the main report and find and open all subreports.
  4. Chose Database menu - Set Location.
  5. Make note of the list of files and the order they are listed in. VERY IMPORTANT!
  6. For each file, set the location of the file to the Company database or System database, depending on the location of the file.
  7. When this is complete, return to the Design screen and chose Database menu - Verify database.
  8. A Btrieve I/O error will occur and require you to give the location of the Info View or Dictionary (*.ddf) used to create the report. Always chose the File.ddf from the appropriate location. All company database files will be in the File.ddf from the company database. The system files will be in the File.ddf in the system database. This will occur for all the files on the list and you MUST do them in the same order that they are listed in the Set Location box as above. VERY IMPORTANT!
  9. When the correct file is selected, a message will appear that the file has changed and allow you to fix the report. Chose Yes to fix the report.
  10. Continue for all files and for all subreports within the primary report and then for the primary report itself.
  11. When complete, save the Crystal report with the original name of the report so that it can be printed from the appropriate ACCPAC program. The fixed reports must be saved in the program/ENG directory.
  12. If programs are installed locally, each workstation must have the fixed reports.

For companies running ACCPAC for Windows Small Business Series that do not have Crystal Reports installed, please contact your ACCPAC Consultant or UniDevCo for more information.

Known Crystal Reports with this issue are:

AR41A/ENG/ARIBSTAT - AR Batch Status

AR41A/ENG/ARIBTCLZ - AR Batch Listing

OE41A/ENG/OECRN01 - OE Credit note

OE41A/ENG/OECRN02 - OE Credit note

OE41A/ENG/OEORDSUM - OE Transaction List - Order - summary

    - OECRNTOT - subreport

    - OEINVTOT - subreport

    - OEORDSMS - subreport

    - OEORSUB - subreport

OE41A/ENG/OEORLST1 - OE Transaction List - Order - detail

    - OEORLST3 - subreport

    - OEORSALE - subreport

    - OEORSUB - subreport

OE41A/ENG/OEINVSUM - OE Transaction List - Invoice summary

    - OECNTOT - subreport

    - OEINVSMS - subreport

    - OEINVTOT - subreport

OE41A/ENG/OEINLST1 - OE Transaction List - Invoice - detail

    - OECRSALE - subreport

    - OEINLSUB - subreport

    - OEINVPRE - subreport

OE41A/ENG/OECNSUM - OE Transaction List - Credit Note - summary

    - OECNTOT - subreport

    - OEINTOT - subreport

OE41A/ENG/OECRLST1 - OE Transaction List - Credit Note - detail

    - OECRSALE - subreport

    - OECRSUB - subreport

OE41A/ENG/OEINL142 - OE Transaction List - Invoice - detail (with AR4.2)

    - OECRSALE - subreport

    - OEINLSUB - subreport

    - OEINVPRE - subreport

OE41A/ENG/OEINV04 - OE Invoice

    - OEINVS-S - subreport

    - PAYED - subreport

    - TERM - subreport

OE41A/ENG/OEINV05 - OE Invoice

    - OEINVS-S - subreport

    - PAYED - subreport

    - TERM - subreport

 

 

or email info@unidevco.com with questions or comments about this web. Last modified: November 22, 2006 Copyright © 2000 - 2005 Uni Development Company Inc. All rights reserved.  All other marks are trademarks or registered trademarks of their respective companies.