Auto populate database in active reports designer

Auto populate database in active reports designer

Posted by: venkatesan_rajendran on 21 December 2023, 5:09 pm EST

• 

  venkatesan_rajendran

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 December 2023, 5:09 pm EST

  Hi,

  We have a requirement to auto set data source while launching active reports designer. I couldn’t find a documentation for that in Active Reports WebDesigner docs. But I could see one in Active Reports JS docs https://developer.mescius.com/activereportsjs/demos/features/designer-resources/angular. I tried to implement the same for active reports web designer like below but it doesn’t work.

  GrapeCity.ActiveReports.Designer.create('#ar-web-designer', {
              appBar: { openButton: { visible: true } },
              editor: { showGrid: false },
              data: { dataSets: { canModify: true }, dataSources: { canModify: true, dataSource: {
                  name: 'SampleDB',
                  connectionProperties: {
                      dataProvider: 'SQL',
                      connectString: 'data source=localhost;initial catalog=TestDB;user id=admin;password=admin;',
                  },
              } } },
          });

  Could someone help me achieve this?

• 

  katyayny.raghuvanshi

  

  • Post Options:
  • Link
    Copy

  Posted 21 December 2023, 6:17 pm EST

  Hi Venkatesan,

  You can use Custom Store to set DataSource and Dataset information dynamically for the WebDesigner. You may refer to our WebDesigner Custom Store sample implementing it. Please refer to the following links to learn more about the same:

  • WebDesigner Custom Store
  • WebDesigner Custom Store GitHub Sample

  Hope this helps!