Browse by Tags

All Tags » SSRS (RSS)

SSRS Tip – Formatting data as a percent by sthompson

Formatting data within SSRS is fairly easy, for each field there is a format property. By referencing and applying the standard format strings (link below...

MMS 2012 – Content Survey by sthompson

From a recent email, please take the time to respond and let this group know what you content you want to see for sessions. Anything SQL related like custom...
Filed under: , ,

How to display Weekday in an SSRS report by sthompson

Recently, I needed to display the weekday in a column heading.  It turns out is was a little more complicated than specifying a function to extract...
Filed under: ,

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...

Cumulative Update package 7 for SQL Server 2008 R2 by sthompson

In case you missed it, Cumulative Update package 7 for SQL Server 2008 R2 was released on June 16, 2011. We ran into a few SSRS 2008 R2 performance issues...
Filed under: , ,

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...

MMS 2011 – BA40 Demo files by sthompson

As mentioned during my presentation on SSRS and ConfigMgr, I’d post the demo SQL and reports used during the session . A couple of notes: - these report...

What’s new in SQL Server 2008 R2 reporting services by sthompson

In researching the list of improvements for SSRS 2008 R2, I found the following list which is quite impressive! http://msdn.microsoft.com/en-us/library...
Filed under: ,

Microsoft Management Summit 2011 – SSRS topic by sthompson

I’m very pleased that a topic session I’ve submitted was accepted, I’ll be back as speaker again at MMS 2011, at Mandalay Bay in Las Vegas. Those that...
Filed under: ,

ConfigMgr 2007 R2 Report Wizard fails to convert certain reports by sthompson

Question from an myITForum community member: I've been trying to get the software 06A reporting functioning correctly in SRS. It works in the old asp...

Count all instances of software registered in Add/remove programs while excluding publishers by sthompson

Received the following question: I want to make a report that list everything from add/remove programs and do a count like the report : “Count of all instances...
Filed under: , , ,

How to show ALL in a report dropdown list by sthompson

Wrote a report recently where I needed an ‘ALL’ selection included for a report parameter with a standard list of items from a query.  This technique...
Filed under: , ,

BIDS Helper Update by sthompson

In case you have not heard of the BIDS helper; a recent update was published and it is an excellent free add on for BIDS (Business Intelligence Development...
Filed under: , , , ,

Configuring SQL Server 2008 Reporting Services on Windows 7 by sthompson

In setting up a local copy of SSRS 2008 on Windows 7 for an upcoming demo, discovered that the local security has been changed from prior versions. ...
More Posts Next page »
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems