So far I have enjoyed the telerik rich suite of products. My customer really likes the dashboard I created for them in silverlight using your chart tools. Thanks for your great tools!
This issue has to do with reporting.
I just updated to 5.1.11.713 Q2 (from 2011 Q1 reports). I had production reports working and they were pulling the connection string information from the Web.config of the reporting Service. I also had them working in the designer. I was happy about it.
According to this article here:
http://www.telerik.com/community/forums/reporting/telerik-reporting/passing-connection-string-to-sub-report.aspx I shouldn't have been able to do that. But I promise that I did.
Additionally in the article you consider it best practices to continue to use the settings file instead of the web.config file. In the above example, I didn't use a settings file, but now the SQL Data source automatically generates it. This causes a problem when you have multiple environments ie (development, test, production) and you have to recompile your code for each deployment. For separation of powers, it isn't practical to have a developer change the settings file and republish it to each environment.
For some reason it appears that the upgrade broke this setup. I didn't think it would be possible, but so far the solution evades me ... I need to be able to run my reports in the designer for testing them, and I need to be able to compile/publish once, and then just change the web.config for each environment I deploy to.
Could you please provide an example of how I can run my reports in VS2010 IDE designer, while still not depending on the settings settings file in deployment to various environments but depending on the web.config of the service.
This issue has to do with reporting.
I just updated to 5.1.11.713 Q2 (from 2011 Q1 reports). I had production reports working and they were pulling the connection string information from the Web.config of the reporting Service. I also had them working in the designer. I was happy about it.
According to this article here:
http://www.telerik.com/community/forums/reporting/telerik-reporting/passing-connection-string-to-sub-report.aspx I shouldn't have been able to do that. But I promise that I did.
Additionally in the article you consider it best practices to continue to use the settings file instead of the web.config file. In the above example, I didn't use a settings file, but now the SQL Data source automatically generates it. This causes a problem when you have multiple environments ie (development, test, production) and you have to recompile your code for each deployment. For separation of powers, it isn't practical to have a developer change the settings file and republish it to each environment.
For some reason it appears that the upgrade broke this setup. I didn't think it would be possible, but so far the solution evades me ... I need to be able to run my reports in the designer for testing them, and I need to be able to compile/publish once, and then just change the web.config for each environment I deploy to.
Could you please provide an example of how I can run my reports in VS2010 IDE designer, while still not depending on the settings settings file in deployment to various environments but depending on the web.config of the service.
1 Answer, 1 is accepted
0
Hi Lorne,
Let's first note that the forum thread you've referenced is pretty old when we were using DataSets as DataSource for the reports. In Q1 2010 we've introduced Data Source Components which have associated wizards with them. The SqlDataSource Component offers you the possibility to save the connectionString in the application configuration file or in the report itself. If you choose to save it in the config file, it is automatically saved in the application settings. Why we need to do this is described in the Using connectionStrings from configuration file KB article, which is partially what the last post of my colleague Svetoslav in the thread tries to cover.
What you need to do to make sure your reports are always connected to the Database is covered in details in this KB. Please review it and let us know should you need further help.
Regards,
Steve
the Telerik team
Let's first note that the forum thread you've referenced is pretty old when we were using DataSets as DataSource for the reports. In Q1 2010 we've introduced Data Source Components which have associated wizards with them. The SqlDataSource Component offers you the possibility to save the connectionString in the application configuration file or in the report itself. If you choose to save it in the config file, it is automatically saved in the application settings. Why we need to do this is described in the Using connectionStrings from configuration file KB article, which is partially what the last post of my colleague Svetoslav in the thread tries to cover.
What you need to do to make sure your reports are always connected to the Database is covered in details in this KB. Please review it and let us know should you need further help.
Regards,
Steve
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>