How to Connect with SSRS from Bold Reports Using Windows Impersonation
There are two options to establish a connection between SSRS and Bold Reports. The first option is to utilize Windows Impersonation information. This means that the connection will be established using the impersonated credentials of the currently logged-in user. The second option involves using system credentials within the application. In this case, the application will provide the necessary credentials to connect SSRS and Bold Reports. Both approaches allow for a secure and authenticated connection between the two systems.
Connect with SSRS using the Windows user
To connect with SSRS using the Windows user, access the system credentials of the application by specifying the ReportServerCredential property within the OnInitReportOptions method of the Report Viewer Controller.
[NonAction]
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
reportOption.ReportModel.ReportServerCredential = System.Net.CredentialCache.DefaultCredentials;
}
Connect with SSRS using the user credentials
If you want to connect with SSRS using user credentials, provide the appropriate network credentials. Within the OnInitReportOptions method of the Report Viewer Controller, specify the ReportServerCredential property as follows:
[NonAction]
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
//Add SSRS Report Server credential.
reportOption.ReportModel.ReportServerCredential = new System.Net.NetworkCredential("UserName", "Password");
}
For more information and related resources, refer to the following:
