syncfusion does support these?

[mohamad abasi]

Hi, i want to use ur report builder but there things i need to know:

1. my platform is angularjs + Microsoft web API 2.0 , do u support it?

(https://docs.microsoft.com/en-us/aspnet/web-api/overview/getting-started-with-aspnet-web-api/tutorial-your-first-web-api)

2.i never want my connection string to be shared in client side.is it possible?

3.i want to manipulate query before it get executed on sql server engine so do support navigation through the tables and adding some conditions and also joins(AST manipulation)?

4. can i customize the table names and field names when i want to show them to customer for building query?

5. hide some column and tables in report designer?

6.saving and loading reports(report files) through my own customized pipeline?

7.is there any way for disabling  designer for some users?

8.your permissions and users definition is based on my customized development or its entirely separate module that has its own user definitions? 

[Vinoth Srinivasan]

Hi Mohamad, 

Thanks for your interest in our Syncfusion Components. 

Query	Response
1. my platform is angularjs + Microsoft web API 2.0 , do u support it?  (https://docs.microsoft.com/en-us/aspnet/web-api/overview/getting-started-with-aspnet-web-api/tutorial-your-first-web-api)	Yes, we will provided the support to use the Report designer in angular application with Web API. Please find the below sample for your reference.  Angular: http://www.syncfusion.com/downloads/support/directtrac/general/ze/AngularSample-973279440  Web API Service: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportDesignerSample-1163715716  Please find the below help documentation for how to create the report designer sample in angular platform.  https://reports.syncfusion.com/documentation/angular/report-designer/getting-started/
2.i never want my connection string to be shared in client side.is it possible?	Yes, we can achieve your requirement by using the shared datasource in reports. If you are using the shared datasource in your report then you can pass the credentials at server side as shown in below code example.  ReportAPIController.cs  public void OnInitReportOptions(ReportViewerOptions reportOptions)              {                  //reportOption.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("<pass Datasource name>", "<pass User name>", "<pass password>"));                  reportOptions.ReportModel.DataSourceCredentials.Add(new DataSourceCredentials("AdventureWorks", "xxxxx", "xxxx"));              }
3.i want to manipulate query before it get executed on sql server engine so do support navigation through the tables and adding some conditions and also joins(AST manipulation)?	Yes, you can add conditions and join tables in our web report designer query designer.
4. can i customize the table names and field names when i want to show them to customer for building query?	Yes, you can able to customize the table or column names while build query. Please refer the below link more details on this,  https://help.syncfusion.com/js/reportdesigner/report-creation#build-query-using-the-query-designer
5. hide some column and tables in report designer?	You can able to hide columns in query designer mode for SQL Server only and we don’t have support to hide dataset(table) based on user condition. Please refer the below UG link to hide columns,  https://help.syncfusion.com/js/reportdesigner/transforming-data/formatting-columns
6.saving and loading reports(report files) through my own customized pipeline?	Yes we can able to save , edit and load the reports using the External server.
7.is there any way for disabling  designer for some users?	Yes, you can customize in your application level to edit or disable the Report Designer based on your user rule like as Report Server.
8.your permissions and users definition is based on my customized development or its entirely separate module that has its own user definitions?

 

Regards, 

Vinoth S.