SQL Server Reporting Services (SSRS) is Microsoft most accomplishing reporting tool. No matter which tool you decided to use in the Microsoft Business Intelligence offerings, SSRS will likely play a part if you really want one solution that does most of what you need. SSRS is part of the SQL […]
Read MoreReporting Services
Toggle Visibility Show As Expanded + – in SSRS
Watch this video demonstration for how to Toggle Visibility as Expanded in your SSRS Report, BICG Training Channel. Reporting Services provides some nice options to allow user’s to feel like they are interacting with the data, by expanding lower levels of detail when they click on the plus (+) sign […]
Read MoreHow to check is null in a Reporting Services Expression
Watch this video demonstration for how to check is null in a Reporting Services Expression http://youtu.be/k2P4Qi20jkA. To perform the equivalent of isnull in a Reporting Services Expression use the IsNothing command. Begin by using IsNothing to determine if your measure is null, wrap it in a conditional IIf statement. […]
Read MoreSSRS – How to Add a Column Group to an existing Table
Watch this video demonstration for how to add a Column Group to an existing table in SSRS, i.e. converting your table from a Tablix to a Matrix http://youtu.be/zM5DRsnH3E0. You have created a table i.e. tablix control in SSRS which is working well however now you want to pivot the dates […]
Read More