tag:blogger.com,1999:blog-8930349235661427759.post1880891593237200931..comments2024-03-28T09:17:24.304+01:00Comments on Keep It Simple and Fast: How to use Dynamic data sources in your SSRS report.André van de Graafhttp://www.blogger.com/profile/07230010757193182052noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8930349235661427759.post-70936111619969417032023-04-21T18:00:47.496+02:002023-04-21T18:00:47.496+02:00In this example, Syngergy is a static data source....In this example, Syngergy is a static data source. You need the static data source to be able to load/refresh your dataset via the "refresh fields" button. However, make sure you do not forget to set your dataset's data source back to the dynamic one, or else the report's dataset will be stuck using the static data source. <br /><br />It's a real shame that one cannot always use a dynamic datasource and still be able to refresh the dataset fields. There is no way to specify a default connection string for your dynamic datasource because Visual Studio and Report Builder will not allow you to refresh fields if your connection string is expression based.<br /><br />"Connection string expressions cannot be evaluated at design time. You must preview or deploy the report to verify the connection."<br /><br />If this were NOT the case, one would be able to specify a default by using a connection string expression like this:<br /><br />=IIF(IsNothing(Parameters!ConnectionString.Value), "Data Source=;Initial Catalog=;", Parameters!ConnectionString.Value)Avi Newmanhttps://www.blogger.com/profile/02274834812690713398noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-7826463194831168522015-11-24T21:59:55.922+01:002015-11-24T21:59:55.922+01:00I can get this to work in Visual Studio (VS2013) b...I can get this to work in Visual Studio (VS2013) but it does not work when deployed to the Report Manager (SQL Server 2014). The embedded data source is not recognized: <br /><br />Cannot create a connection to data source 'Various'. (rsErrorOpeningConnection)Tony Chttps://www.blogger.com/profile/17006754089850914184noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-30802934235863821622015-11-02T17:30:57.098+01:002015-11-02T17:30:57.098+01:00One small note,
If you're amending an existin...One small note,<br /><br />If you're amending an existing report, please make sure the ServerName/DatabaseName parameters are parameters number 1 & 2 in the list (push them up).<br /><br />Otherwise on run-time you'll get the error: <br /><b>An error occurred during local report processing.<br />An error has occurred during report processing.<br />Error during processing of the ConnectionString Expression of Data Source 'DynamicDataSource'.</b>RoniVeredhttps://www.blogger.com/profile/03899508013625746563noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-65728461871554713212015-08-21T11:57:03.203+02:002015-08-21T11:57:03.203+02:00Very nice article & thank you so much André va...Very nice article & thank you so much André van de Graaf !<br /><br />SatheeshSatish With Uhttps://www.blogger.com/profile/05590067931869731430noreply@blogger.com