Hi everyone,
I'm having an issue with Telerik Report Viewer (HTML5 version) and Telerik Report Designer. I'm trying to change the database connection dynamically, and although the new connection string is being passed correctly (I’ve confirmed this by printing the in-memory values), the report viewer keeps using the initial connection and doesn't apply the new one.
What's even stranger is that after clearing cookies, browser data, and restarting the site, it still sticks to the first connection it received. It feels like Telerik stores this connection internally (maybe through caching or some static variable) and won’t allow it to update.
Has anyone experienced something similar or knows how to force the viewer to use the new connection?
Any suggestions or guidance would be greatly appreciated.
Thanks in advance.
1 Answer, 1 is accepted
Hello Jhonatan,
Thank you for reaching out.
You can check the name of the connection string in the SqlDataSource components, as it should be the same as in appsettings.json.
Ensure that the name of the connection selected in the SqlDataSource component matches the name of the connection defined in the ConnectionStrings property in the appsettings.json file and that the correct configuration file is loaded in the application.
Note that you also have the option of embedding the connection string in the report definition(see the second option in the above image) if you do need to change the connection string for the different environments.
If you want to make changes, you can get a Telerik.Reporting.Report instance and update all DataSource properties of data items in it. Please consider the example in Changing the connection string dynamically according to runtime data.
If that doesn't help, could you please send me a Trace log and a Fiddler? Also, it would be helpful if you could send me your Program.cs and appsettings.json, and if you could take a picture of your SqlDataSource setup.
I hope the provided information will help resolve the issue. Let us know if you have further questions.
Regards,
Ivet
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 1
Thanks,
but that's not the issue. I handle it in the following way:
The problem happens when I pass a dynamic connection. For example, I manage multiple connections, and when I switch connections, the system gets stuck on the first one. It's very strange because it should switch connections without a problem.
It doesn't even change correctly after clearing cookies and browser data. Even when I open another browser to test the second connection, it still shows data from the first one. It's as if Telerik Report caches or "sticks" to the initial connection. It's really strange.
Hi Jhonatan,
Could you tell me what type of project you have - .NET or .NET Framework? If it's .NET, we take the string from the IConfiguration given to ReportServiceConfiguration. However, if you have set it as a singleton as we recommend, it is taken only at the beginning and cannot be replaced.
The data is pulled from the server, so if you make changes to the viewer, nothing will change on the server where the data is fetched from.
To be more helpful, I will need your project so I can test it and try to find a solution to the issue. Could you please send me your project?
If you are hesitant to send your report and data here, you can open a ticket and provide the details there.