InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 17:08:50 GMT20http://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxYou have correctly identified the problem. I defined a shared datasource instead of local. Thank you for pointing it out.Since it's not a shared datasource, I ran into another challenge. I cannot test the ErrorList by clicking the "!" button and have to use the preview tab instead. I now have a different error to debug. Something about [rsErrorReadingDataSetField] and [rsMissingFieldInDataSet]. I will work on this.Again, thank you for your help. It will be a great tool for us when I get this working.Loi.Mon, 20 Jun 2011 11:03:49 GMTloi.nguyen2000http://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxI've not seen this before but Googled it and it seems that this is by design. The data source for reports with dynamic connection functionality needs to be local (i.e. not shared) to the report itself. So the the table where you pull the list of server names from needs to be a table on your local instance.Wed, 15 Jun 2011 00:44:49 GMTCarolyn Richardsonhttp://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxI cut and pasted the scripts from your article, and it is: ="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=master" One thing I notice from my data source designer screen is mine had Edit button highlighted and the F(x) button greyed out. Yours is the opposite - F(x) highlighted and the Edit button greyed out. Is this something we set on server configuration? I'm not able to insert screen prints from my designer screen here for you to see. Tue, 14 Jun 2011 12:20:49 GMTloi.nguyen2000http://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxI think there may be something wrong with the syntax of the connection string your using, can you post it here?Tue, 14 Jun 2011 12:02:43 GMTCarolyn Richardsonhttp://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxHello Carolyn, this is a great article. It is exactly what I was looking for in my new job assignment. One problem I have is I could not set the data source name dynamically. I'm in SSRS 2K5 environment. I got an error message " Microsoft Report Designer - Connection string expressions are not allowed in shared data sources." Right now, I just hard coded the server name that I need to see the log most often to use it. What do I need to do to be able to configure the datasources dynamically?Tue, 14 Jun 2011 10:29:36 GMTloi.nguyen2000http://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxPoints noted thanks.You can use the xml file:-In Reporting Services create a new blank report and from the top menu select View then Code. Replace all the XML displayed with the XML contained in the attached file. If you switch to layout the report will now appear in design view.Tue, 06 May 2008 10:39:46 GMTCarolyn Richardsonhttp://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxGreat article.I liked the technique of using the parameter in the connection string.Didn't think that was possible,Nice hack!Just a couple of small problems though:1) Your creation script does not match the xml sample report: Should read: [code]CREATE TABLE [dbo].[ServerList] ( [ServerName] [nchar](50) NULL ) ON [PRIMARY][/code]2) Reporting Services doesn't like extensions of XML for reports, It prefers RDL. Rename the example file to RDL and it will be easier to integrate.Thank you for including the sample files!Really made life easier!Tue, 06 May 2008 10:23:36 GMTCharley Joneshttp://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxVery good practical and useful article. :)Tue, 06 May 2008 10:12:55 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxVery cool, very useful. I can definitely use something like this, but I have GOT to learn Reporting Services first! :hehe:Tue, 06 May 2008 10:02:10 GMTWayne Westhttp://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxGreat article ! I will use this . Thanks...Tue, 06 May 2008 08:56:54 GMTfthomas-735932http://www.sqlservercentral.com/Forums/Topic495379-369-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Reporting+Services/62934/">Using Reporting Services to Search the SQL Server Log</A>[/B]Mon, 05 May 2008 21:42:29 GMTCarolyn Richardson