ActiveReport 13 web designer & shared Data Source

ActiveReport 13 web designer & shared Data Source

Posted by: fabio.panero on 19 March 2019, 4:01 am EST

• 

  fabio.panero

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 March 2019, 4:01 am EST

  Hi,
  
  I’m not able to provide a shared data source (SQL) to the web designer.
  
  I would like to provide a shared data source with the possibility for the user to create a dataset into the browser in the same way that I saw in ActiveReport Server12.
  
  Can you provide me a sample? In all sample installed the web designer receive only dataset and is not possible to create a custom dataset.

  Thanks.

  Fabio

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 19 March 2019, 5:59 pm EST

  Hello Fabio,

  Currently, it is not possible to create a dataset in the browser in AR13. Also, the same request has opened in the following S1 ticket:
  
  https://supportone.componentone.com/casedetail/370473

  Our developer team already working on this and will update you once I get any information from them.

  Thanks.

• 

  fabio.panero

  • Post Options:
  • Link
    Copy

  Posted 19 March 2019, 8:42 pm EST

  Ok, Thanks,
  
  You have very huge documentation but for me, it’s not clear when a certain functionality described are available in all platform (desktop, web old html5 or new js…etc… ) or only in a specific one.
  
  I thought that Active report server was made with your “component” library (active report professional) with same business value like agent, mail, etc… and when I saw the shared datasource in the web designer (active report server) I thought that it was possible to use also in a complete custom application with a library.

  So, I’m waiting for the ticket answer.

  Thanks

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 19 March 2019, 9:01 pm EST

  Hello,

  Actually, WebDesigner is newly introduced in AR13. Hence it has some limitation now. We are working on it to enhance the Web Designer in our future release.

  Yes, ARS uses the AR library to create/render/export the report. However, ARS is a report server for enterprise teams that’s why it has some inbuilt UI to create datasource/dataset. Whereas WebDesigner in AR13 is present as a component which can be embedded into web applications only to create and edit reports.

  Here’s are some Web Designer documentation link:
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#ActiveReportsWebDesigner.html
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#WebDesignerPluginsAPI.html

  Thanks for your patience.

  Thanks.

• 

  Sergey.Romanov

  

  • Post Options:
  • Link
    Copy

  Posted 21 March 2019, 7:38 pm EST

  Hello ,

  It is correct, WebDesigner does not provide own UI with the dataset constructor in the developer’s edition of ActiveReports. However, the format of WebDesigner dataset is trivial, so it is not a hard task to create the new dataset at run time.
  
  Here is a sample of dataset:

  {
  	"DataSet": {
  		"Name": "NorthwindDataSet",
  		"Query": {
  			"CommandText": "select * from Products",
  			"DataSourceName": "RemoteNorthwind"
  		},
  		"Fields": [
  			{
  				"DataField": "ProductId",
  				"Name": "ProductId",
  				"DataType": "Integer",
  				"Aggregate": "Count"
  			},
  			{
  				"DataField": "ProductName",
  				"Name": "ProductName",
  				"DataType": "String",
  				"Aggregate": "Count"
  			}
  
  		]
  	},
      "DataSource": {
          "Name": "RemoteNorthwind",
          "ConnectionProperties": {
              "DataProvider": "SQL",
              "ConnectString": "Data Source=1.1.1.1;Initial Catalog=Northwind;User ID=1;Password=1"
          }
  } 
  

  If you do not want to show the connection string of the client side, then you could replace the common datasource entry by the shared one, so the connection string will be always stay on the server, e.g.:

  {
  	"DataSet": {
  		"Name": "NorthwindDataSet",
  		"Query": {
  			"CommandText": "select * from Products",
  			"DataSourceName": "RemoteNorthwind"
  		},
  		"Fields": [
  			{
  				"DataField": "ProductId",
  				"Name": "ProductId",
  				"DataType": "Integer",
  				"Aggregate": "Count"
  			},
  			{
  				"DataField": "ProductName",
  				"Name": "ProductName",
  				"DataType": "String",
  				"Aggregate": "Count"
  			}
  
  		]
  	},
  	"DataSource": {
  		"Name": "RemoteNorthwind",
  		"DataSourceReference": "C:/dc_folder/Northwind.rdsx"
  	}
  } 
  
  

  Thanks,
  
  Sergey Romanov.