Sage 100

 View Only
  • 1.  Created a Crystal Report for Sage 2017. Trying to

    Posted 09-20-2018 10:00
    Created a Crystal Report for Sage 2017. Trying to export it to an ODBC format. Get the 'Failed To Export Report' message as soon as I click OK after choosing the export format (have tried Access and dBase. I've googled, checked the Knowledgebase and the community. Nothing seems to relate to this. I've stripped down the report to just include data - no text fields, headers, no subreports, etc. There are a LOT of records, but it doesn't even begin to export so I'm not sure that is the issue. To be honest, I've never tried exporting to ODBC before but Excel can't handle the record count. Any ideas? Thanks!!


  • 2.  RE: Created a Crystal Report for Sage 2017. Trying to

    Posted 09-20-2018 10:18
    When I have a large dataset I export to csv.


  • 3.  RE: Created a Crystal Report for Sage 2017. Trying to

    Posted 09-20-2018 10:21
    Same here


  • 4.  RE: Created a Crystal Report for Sage 2017. Trying to

    Posted 09-20-2018 11:00
    I was able to get it to export. Didn't realize I had to set up an ODBC connection BEFORE exporting from Crystal - I assumed it would let me do it during the export. Thanks!


  • 5.  RE: Created a Crystal Report for Sage 2017. Trying to

    Posted 09-20-2018 13:53
    Dawn, next time, dump it to Access...


  • 6.  RE: Created a Crystal Report for Sage 2017. Trying to

    Posted 09-20-2018 15:11
    When I need something in a database, I pull instead of push.