Browse by Tags

All Tags » SQL Server » Reporting (RSS)

What is old, then new again? ODBC by sthompson

Read the following blog entry, found this to be very fascinating. http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with...

Using Custom code in Report Builder by sthompson

As mentioned in an earlier post , it is possible to add custom code to Report Builder and BIDS (Business Intelligence Developer Studio).  There are...

SSRS 2005 to 2008 migration issue by sthompson

Just found an issue with an SSRS project migration from SQL Server 2005 to SQL Server 2008 R2.  First the report, newly converted to SSRS 2008 failed...

Report Server Explorer at Codeplex by sthompson

If you have not seen this utility for SQL Server Reporting Services , it is an excellent edition to any tools you may have to manage your SSRS environment...

How to change SQL Server date time fields for report display by sthompson

A recent question on myITForum regarding a report query for ConfigMgr 2007: In a SQL query how do I convert the data/time that is returned in 2010-04-11...

How to create a dynamic company logo for reports by sthompson

Have you ever needed to dynamically change the company logo displayed on a report? This technique will work for Visual Studio 2005 and 2008.  You...
Filed under: , ,

Custom Software Update Compliance Report for ConfigMgr 2007 by sthompson

Had a special request recently to create a custom compliance report based on the selection of a software update list and collection name. Besides the columns...

SSRS 2005 Installation issue encountered for ConfigMgr 2007 R2 by sthompson

Recently an interesting installation issue occurred for myITForum member Eric Morrison, while attempting to get SQL Server Reporting Services 2005 installed...

How to back up SCCM 2007 R2 Reporting Services by sthompson

A recent post on the MVP alias got me thinking that others may not know that the standard ConfigMgr 2007 backup task does not back up the SSRS reports...

FAQ - SQL Server Reporting Services Integration with ConfigMgr 2007 R2 by sthompson

Just in case you have not seen this blog entry from Bhaskar Krishnan, member of the ConfigMgr Team. This blog is a very nice summary of the integration...
Filed under: , ,

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 by sthompson

This product has been around for a few months, I first learned about this Report Builder utility while at the MVP summit in early March. I finally got...
Filed under: ,

SCCM 2007 R2 Reporting Services Online links by sthompson

I've found the following online resource links helpful in working with ConfigMgr 2007 SQL Server Reporting Services. SQL Server 2005 http://msdn.microsoft...
Filed under: , ,

Installing SCCM 2007 R2 SQL Server Reporting Services by sthompson

I've recently had a chance to work with Microsoft System Center Configuration Manager (SCCM) 2007 SQL Reporting Services Reporting; which is new with...

How do I use a wildcard for add remove program information? by sthompson

Question: What I really could use is report #96 ("Computers with specific software registered in Add Remove Programs"), that allows me to include...

How do I return all records when there are no matching rows in a joined table? by sthompson

Question from the myITforum list: Need some help from all you experts out there, I have created an SMS report for all machines in a particular collection...
Filed under: , ,
Powered by Community Server (Commercial Edition), by Telligent Systems