Activereportsjs MySql data source

Activereportsjs MySql data source

Posted by: 8888post on 22 January 2020, 8:19 am EST

• 

  8888post

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 January 2020, 8:19 am EST

  How to use MySQL in ActiveReportsJS 1.1
  
  I installed odbc driver and add connection string but not working!

  
  Driver={MySQL ODBC 8.0 ANSI Driver};Server=localhost;Database=salary;User=root;Password=123456; Option=3;
  
  

  Do you have any example?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 27 January 2020, 10:44 am EST

  Hello,

  ActiveReportsJS only supports JSON data. You can create a WebAPI which converts your data into valid JSON data. Then, you can consume the WebAPI in your reports.

  Thanks,
  
  Mohit