Archive for the ‘ Miscellaneous ’ Category

Suppress zero in Crystal Report

It’s quite straight forward trick. Right Click on Report Field, go to Format Object, Click on Number, Check the Suppress if Zero Field. Your Report will not show zero values.
Suppress Zero in Crystal Report
A Rahim Khan


Customized Thousand Separator in Crystal Report

Crystal Report Provides an easy to use default thousand separator for numeric Fields. You can use it by checking Thousand Separator from Field Properties.

However, when you want your own kind of thousand separators you have to go through more complications. You will have to use Formula Fields of Crystal Report. Continue reading

2010 in review

The stats helper monkeys at mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

Healthy blog!

The Blog-Health-o-Meter™ reads Wow.

Crunchy numbers

Featured image

A helper monkey made this abstract painting, inspired by your stats.

The average container ship can carry about 4,500 containers. This blog was viewed about 18,000 times in 2010. If each view were a shipping container, your blog would have filled about 4 fully loaded ships.

In 2010, there were 48 new posts, growing the total archive of this blog to 61 posts. There were 85 pictures uploaded, taking up a total of 4mb. That’s about 2 pictures per week.

The busiest day of the year was October 27th with 160 views. The most popular post that day was Insert, Update, Delete with DataGridView Control in C# (Windows Application).

Where did they come from?

The top referring sites in 2010 were,,,, and

Some visitors came searching, mostly for mysql function return data set, mysql function return table, return data set mysql function, datagridview combobox, and insert,update, delete database of winform in c#.

Attractions in 2010

These are the posts and pages that got the most views in 2010.


Insert, Update, Delete with DataGridView Control in C# (Windows Application) April 2010


ComboBox with DataGridView in C# April 2010


How to Export Data to or Import Data from Excel in SQL Server 2005 April 2010


File Download, Upload, Delete in FTP Location using C# September 2010


BULK INSERT T-SQL Command to Import Data from Text or CSV File in SQL Server 2005 April 2010

SQL to Select Random Rows from Table

Selecting Random Rows from Application Layer is always a mess. After some googling, I find those SQL Commands to SELECT Random Rows in different Databases. Here, I just put those Commands together for convenience.

-- SQL Server

Continue reading

Detecting Simple Networking / Connectivity Problems

Can you think of an hour without Connectivity, particularly in business places? Most of us depend on Network Connectivity for our daily job. So, what happens when you are not able to connect your Server, you end up calling your Networking Guy. Here, I am going to describe some easy and handful tricks to detect most of your networking troubles.
Continue reading