CRYSTAL REPORTS ON SAGE 200 EVOLUTION

SOLVED

Hello

Is there a way to use crystal reports on sage 200 evolution as we normally use it on Sage 300?

This because I want to create my own views on the database which will be used to populate information from  database.

Alternatively is there a way to use custom views on report builder?

Parents
  • +1
    verified answer

    Hi Ramadhan

    If you can establish a link between Crystal Reports and the Evolution company database by e.g. a SDK connection (or any interal tool within Crystal Tools) i'm sure it may be possible to write your own reports 

    This means you could then be possible to make use of the standard Evolution company DB views to help you with your report layout development

    The standard DB views (as also used in all Evolution standard reports) are encrypted and cannot be edited.

    However, I think (not entirely sure) you may be able to create your own custom views as added onto the Evolution company database and then make use of them on the Common | Reports| Report Builder utility.

    Kind Regards

    Bennie

  • 0 in reply to Bennie Pienaar

    Yes, I can establish the link between Crystal Reports and Sage Evolution DB but on which environment I'll run the reports? Crystal reports can run on Sage 300 but  I don know how to run crystal reports on Sage evolution. I have already created the report and they work fine. But how i can link it on the Sage Evolution so that when user log in can access the reports.

Reply
  • 0 in reply to Bennie Pienaar

    Yes, I can establish the link between Crystal Reports and Sage Evolution DB but on which environment I'll run the reports? Crystal reports can run on Sage 300 but  I don know how to run crystal reports on Sage evolution. I have already created the report and they work fine. But how i can link it on the Sage Evolution so that when user log in can access the reports.

Children
  • 0 in reply to Ramadhan Ngallen

    Hi Ramadhan 

    My sincere apologies for the late response

    Within the Evolution company you will not be able to open Crystal reports and run it on the Evolution company database.

    the best possible option here should be to run the reports on the Evolution company database but from within the Crystal reports platform itself (which is opened outside of the Evolution company)

    This is how I think it may be possible work, but can unfortunately not confirm it will definitely work as I've never set this scenario up before. 

    Kind Regards

    Bennie