May 5, 2008 at 9:42 pm
Comments posted to this topic are about the item Using Reporting Services to Search the SQL Server Log
May 6, 2008 at 8:56 am
Great article ! I will use this . Thanks...
May 6, 2008 at 10:02 am
Very cool, very useful. I can definitely use something like this, but I have GOT to learn Reporting Services first! :hehe:
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 6, 2008 at 10:12 am
Very good practical and useful article. 🙂
May 6, 2008 at 10:23 am
Great 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:
CREATE TABLE [dbo].[ServerList]
( [ServerName] [nchar](50) NULL )
ON [PRIMARY]
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!
Charley Jones
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group
May 6, 2008 at 10:39 am
Points 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.
June 14, 2011 at 10:29 am
Hello 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?
June 14, 2011 at 12:02 pm
June 14, 2011 at 12:20 pm
I 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.
June 15, 2011 at 12:44 am
I'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.
June 20, 2011 at 11:03 am
You 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.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply