Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Using Reporting Services to Search the SQL Server Log Expand / Collapse
Author
Message
Posted Monday, May 5, 2008 9:42 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 2:55 AM
Points: 1,466, Visits: 3,036
Comments posted to this topic are about the item Using Reporting Services to Search the SQL Server Log

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #495379
Posted Tuesday, May 6, 2008 8:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 21, 2014 8:16 AM
Points: 21, Visits: 141
Great article ! I will use this . Thanks...
Post #495710
Posted Tuesday, May 6, 2008 10:02 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:22 AM
Points: 914, Visits: 2,051
Very cool, very useful. I can definitely use something like this, but I have GOT to learn Reporting Services first!

-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Post #495755
Posted Tuesday, May 6, 2008 10:12 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:15 AM
Points: 5,471, Visits: 1,402
Very good practical and useful article. :)


Post #495763
Posted Tuesday, May 6, 2008 10:23 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 10:45 AM
Points: 11, Visits: 4
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
Post #495777
Posted Tuesday, May 6, 2008 10:39 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 2:55 AM
Points: 1,466, Visits: 3,036
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.


Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #495789
Posted Tuesday, June 14, 2011 10:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 12, 2014 12:59 PM
Points: 8, Visits: 83
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?
Post #1125168
Posted Tuesday, June 14, 2011 12:02 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 2:55 AM
Points: 1,466, Visits: 3,036
I think there may be something wrong with the syntax of the connection string your using, can you post it here?

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #1125228
Posted Tuesday, June 14, 2011 12:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 12, 2014 12:59 PM
Points: 8, Visits: 83
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.
Post #1125247
Posted Wednesday, June 15, 2011 12:44 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 2:55 AM
Points: 1,466, Visits: 3,036
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.

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #1125479
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse