1. Home
  2. Forum
  3. Report Platform
  4. Report Viewer Promps Username and Password
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Report Viewer Promps Username and Password

Hello


The Report Viewer is prompting for Username and Password for a RDL created with Bold Report Designer.

I have specified 

 reportOption.ReportModel.DataSourceCredentials.Add.....



3 Replies
AM Arumugasami Murugesan Syncfusion Team October 17, 2022 08:19 AM UTC

Hi Samson,


Thanks for contacting Bold Report support.


you can add the connection string programmatically in the API controller in the OnInitReportOptions method. You need to use the below code snippet to pass the data source credentials.


  [NonAction] 

public void OnInitReportOptions(ReportViewerOptions reportOption) 

{ 

        reportOption.ReportModel.DataSourceCredentials.Add(new BoldReports.Web.DataSourceCredentials() { Name = "AdventureWorks",    ConnectionString = "Data Source=dataplatformdemodata.syncfusion.com;Initial Catalog=AdventureWorks;" , UserId = "demoreadonly@data-platform-demo" , Password = "N@c)=Y8s*1&dh"}); 

} 


Please refer to the below documentation for your reference.

https://help.boldreports.com/embedded-reporting/aspnet-core-reporting/report-viewer/ssrs-report/#change-data-source-connection-string

https://help.boldreports.com/embedded-reporting/how-to/change-the-report-datasource-dynamically/


Regards,

Arumugasami M


SA Samson October 17, 2022 08:25 AM UTC

Hello


Thanks for the reply,. I tried this and it worked.

However when I migrated the reports to another Database, I was forced to change the Datasource connection settings on the designer for the reports to work, is that the case or there is another way.


AM Arumugasami Murugesan Syncfusion Team October 18, 2022 09:30 AM UTC

Hi Samson,


Thanks for the update,


Yes, we will be forced to change the data source connection string, which is in the API controller in the OnInitReportOptions method. The report viewer will preview without a prompt only if you use the data source connection string programmatically.

Otherwise, you have to give the username and password credentials in the connection string in advanced options and set the Authentication Type to None. Please have a look at the below snap for your reference.


SNAP:


Regards,

Arumugasami M.


Loader.
Up arrow icon