If you are coming from Crystal Reports background then you must be aware of a property called Suppress if 0 in Crystal Reports. By default, this property is disabled resulting in zero values being displayed on your report. When checked, all the zero values are suppressed by replacing 0 with a blank space.

SQL Server Reporting Services (SSRS) is quite young when compared to Crystal Reports. It is not as powerful as Crystal Reports but it definitely bundles simplicity and seamless integration with SQL Server data and Visual Studio.

Here I show you how to implement Suppress if 0 functionality in SSRS. In my example I have used SQL Server 2008 Reporting Services. Before starting let's see how the report looks when opened in browser before suppressing zero values:

To suppress zero values, go to Business Intelligence Development Studio and open the report design. My report design looks like this: More...

tangible T4 Editior:  Quickly write your own .NET Code Generator via T4 Text-Templates (.tt-Files) with Intelli-Sense & Syntax-Highlighting. tangible T4 Editor comes with UML-Style modeling tools and can generate from diagrams, database schemas, xml, word, excel sources, or any other data source.

T4 Toolbox: A set of ready-to-use code generators and T4 extensions for Visual Studio. Quickly build powerful C# or VB templates that generate multiple output files or simply use existing templates for LINQ to SQL, Entity Framework and more.

Devart T4 Editor: A powerful Visual Studio add-in for editing T4 templates with syntax highlighting, intellisense, code outlining, and all features of a first-class text editor add-in for Visual Studio. It provides very high performance and makes creating T4 templates easier and faster. As well as ensuring extremely high level of performance, it also speeds up and facilitates the creation of T4 templates.

My blog IRohitable has a new sub-branch now: life.irohitable.com.

 Note the new category on top with the title My Days My Life.

While starting Ruby and Rails, I read a couple of tutorials but soon lost interest until I met a monk. Yes, you read it right, a Monk, and this monk guided me to the path of enlightment. My journey to the world of Ruby on Rails started from here:

RubyMonk

The rubymonk Primer is a free introductory course on Ruby. It is an interactive learning platform from C42 Engineering. Learn Ruby with LESSONS, solve PROBLEMS or view the CONTENTS. RubyMonk combines the advantages of learning from a book, pairing with a mentor and actual hands-on coding and delivers it on a fun interactive platform for amateurs and enthusiasts who are discovering the Ruby language.

courtesy: www.rubymonk.com

In the journey, I met a man with code ... More...

This week I have SQL Server tools for you.

SQL Scripter: Powerful tool for Microsoft SQL Server 7.0/2000/2005/2008 database administrators and developers to generate data scripts in a readable and executable T-SQL format.

NetWrix SQL Server Change Reporter: Monitor and review administrative changes on SQL servers and at database levels. Detect early all unauthorized and unwanted changes that can lead to server and database downtime. The Freeware Edition has few limitations.

SQL Sentry Plan Explorer: A FREE tool that builds upon the graphical plan view in SQL Server Management Studio (SSMS) to make query plan analysis more efficient. It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6. It does not require a collector service or database.

FlySpeed SQL Query: Free SQL query tool for any database. It facilitates the process of building SQL by letting you quickly drag and drop tables to create queries, from simple to complex, and combine visual query building with direct SQL text editing.