CRYSTAL REPORTS

REALLY want to know why SAGE 50 Canadian did not tell us that they were going to discontinue the capability to use Crystal Reports for forms. 

The fact that we hear about this part way through the year is ridiculous. Add to that the fact that they have not improved the functionality of their own report designer and they cannot open up the channels for us to choose more data fields thus replacing our Crystal Reports formatted form within their own software. 

They offer no solution to the problem they simply state that as of June 2014 CR will cease to work.

Very amateurish on their part!!

Parents
  • Hasn anyone solved this?  I am a crystal report developer and i have a system that would work for this, working on creating it as a printer file so it would flow directly from sage 50.  would anyone be interested in this?

  • in reply to MITAITHECAT

    Sorry i mean print driver

  • in reply to MITAITHECAT

    The Sage approach is to allow an export of the data that the old Crystal Reports forms used to use.  

    When printing the Sage forms, the data export doesn't happen, andinvoice has not been posted  It's not yet possible to query the database for other information relating to the invoice, so the only data available is what is being sent to the print driver.  (even though the Project data is available, it's not possible to know which Projects are allocated to the invoice.

    There are already some third party products that use other triggers to work around the lack of any print integration.  (i.e. they watch for a data file to be created, or watch the Sage 50 database for any updates to the tables that store invoices (XLGL appears to do this).

  • in reply to RandyW

    I have a working solution for this. You setup a NUL print driver and use that as the default for the forms, then I have a C# program that monitors for changes to the CSV files and auto-prints the Crystal Reports. I'm able to custom-select the report based on the customer type, print any type of form, etc. It works quite well.

  • in reply to Justin Cowling

    I had thought that the Crystal Reports CSV files did not get updated when the Sage 50 type forms were selected - that's how it acted up to the 2014.2 release.  

    For the 'Sage 50' forms, there were a half dozen printing fields added for 2015 as a sop for pulling the Crystal Reports integration in the 2014.3 release, but then there was a new bug introduced in printing January 1, 1901 in blank ship date fields.  This was fixed in the 2015.2 release, and now there is a bug in the form selection.  Thanks for trying, Sage.

    Kudos to all the independent developers working to keep a reasonable level of form printing capability available.

  • in reply to RandyW

    There is an option in the form setup to continue generating the CSV files.

Reply Children
No Data