Adding RDL data source programmatically

[Karmen]

Hi!

I am using a RDL template and I would like to programmatically add my data source specifying SQL CE database file location (pathToApplication\database.sdf). 

I have seen these two lines in the documentation under Generating RDLC Reports:

ReportDataSourceCollection dataSources = new ReportDataSourceCollection();
dataSources.Add(new ReportDataSource { Name = "ProductCatalog", Value = ProductCatalogSource.GetData() });

but it does not do what I want since the collection or ReportDataSource itself does not contain the setPath() method or something similarly.

I would be glad if you could help me out.

In advance thank you for your help.

Regards, 

Karmen Gostiša

[Vinoth Srinivasan]

Hi Karmen, 

 

Thanks for contacting Syncfusion support. 

 

The RDL reports has connection details within the report datasource to get necessary data for rendering, so you can’t set the data values in code behind using the shared code snippet. You can programmatically edit/modify the RDL reports to change the “connection string” of existing datasource or you can add new datasource. Refer to the following Knowledge base to edit the report definition of a report in code behind. 

 

https://www.syncfusion.com/kb/7083/how-to-edit-a-report-at-runtime 

 

Regards, 

Vinoth S. 

[Yusuf juanda]

when my report is displayed and i get a message like this

at Syncfusion.Report.Intenal.Data.DataExtensionProcessor.UpdateDataExtension(String connectionString, String cmdTxt, List`1 parameters, DataSource dataSource, DataSet dataSet, ExtensionHelper helper) at BoldReports.RDL.Data.ProcessedData.UpdateDataSourceObjects(DataSetInformation dataSetInfo) at BoldReports.RDL.Data.ProcessedData.UpdateDataSet(String name) at BoldReports.RDL.Data.ReportModel.UpdateDataSource() at BoldReports.RDL.Data.ReportModel.Evaluate(Boolean isSubReport) at BoldReports.RDL.Data.ReportModel.Evaluate() at BoldReports.Web.ReportViewer.Internal.ReportViewerLayoutModel.GetModelInfo(Boolean printMode, Boolean isDrillDown, Boolean isRefresh, Boolean isSort) at BoldReports.Web.ReportViewer.Internal.ReportViewerInternalHelper.GetPageModel(Boolean isDrill, Boolean isSort) at BoldReports.Web.ReportViewer.Internal.ReportViewerInternalHelper.GetPageModelProcess(Boolean isDrill, Boolean isSort) at BoldReports.Web.ReportViewer.Internal.ReportViewerInternalHelper.ProcessReport() at BoldReports.Web.ReportViewer.ReportHelper.ProcessReport(Dictionary`2 jsonArray, IReportController reportController, IMemoryCache memoryCache) at CustomReport.Api.ReportController.PostReportAction(Dictionary`2 jsonObject) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeNextResourceFilter() at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeAsync() at Microsoft.AspNetCore.Mvc.Routing.ControllerRequestDelegateFactory.<>c__DisplayClass10_0.<CreateRequestDelegate>b__0(HttpContext context) at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context) at System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.HostFiltering.HostFilteringMiddleware.Invoke(HttpContext context) at Microsoft.WebTools.BrowserLink.Net.BrowserLinkMiddleware.InvokeAsync(HttpContext context) at Microsoft.WebTools.BrowserLink.Net.VsContentMiddleware.InvokeAsync(HttpContext context) at Microsoft.AspNetCore.Watch.BrowserRefresh.BrowserRefreshMiddleware.InvokeAsync(HttpContext context) at System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.AspNetCore.Watch.BrowserRefresh.BrowserRefreshMiddleware.InvokeAsync(HttpContext context) at Microsoft.AspNetCore.Builder.Extensions.MapWhenMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Hosting.HostingApplication.ProcessRequestAsync(Context context) at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application) at System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application) at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequestsAsync[TContext](IHttpApplication`1 application) at System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequestsAsync[TContext](IHttpApplication`1 application) at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http2.Http2Stream`1.Execute() at System.Threading.ThreadPoolWorkQueue.Dispatch() at System.Threading.PortableThreadPool.WorkerThread.WorkerThreadStart() at System.Threading.Thread.StartCallback()

[Arumugasami Murugesan]

Hi Karmen,

Thanks for the update,

Please find the details from the below table,

Query	Response
I am using a RDL template and I would like to programmatically add my data source specifying SQL CE database file location (pathToApplication\database.sdf).	You can generate the RDL and RDLC reports programmatically in the report viewer. Please refer to the below documentation https://help.boldreports.com/embedded-reporting/aspnet-core-reporting/report-viewer/how-to/generate-rdl-rdlc-report-programmatically/   Please refer to the below documentation to change the data source dynamically   https://help.boldreports.com/embedded-reporting/how-to/change-the-report-datasource-dynamically/
I have seen these two lines in the documentation under Generating RDLC Reports:   ReportDataSourceCollection dataSources = new ReportDataSourceCollection(); dataSources.Add(new ReportDataSource { Name = "ProductCatalog", Value = ProductCatalogSource.GetData() });  Copy but it does not do what I want since the collection or ReportDataSource itself does not contain the setPath() method or something similarly.	For rendering the RDLC report, Please refer to the below documentation https://help.boldreports.com/embedded-reporting/wpf-reporting/report-viewer/rdlc-report/   If you are still facing any issue, could you please share the additional details of this issue with issue snap with us? It will be helpful for us to validate and provide the solution at the earliest.

Regards,

Arumugasami M.

[Arumugasami Murugesan]

Hi Karmen,

Please ignore the last update,

Could you please share the additional details of this issue with us? And also, is it possible to share your reproducible simple sample with us? It will be helpful for us to validate and provide the solution at the earliest.

Regards,

Arumugasami M.