Number type input fields validation using JQuery

Using JQuery it is easy to validate numeric data in input fields.

Below code validates numeric input in the input type fields.
For this we only need to add .number as class for the input html tags in which we need to validate numeric data.

$('input.number').blur(function () {

    var value = $(this).val();

    if (value == undefined || value == "") {

        $(this).parent().find("span").remove();

        return;

    }

    if (isNaN(value)) {

        $(this).parent().find("span").remove();

        $(this).parent().find("br").remove();

        $(this).parent().append("</br><span class='error'>Please Enter Number</span>");

    }

});

Above blur event shows the Please Enter Number error message just after user moves cursor from input field.

Creating SharePoint 2010 List Instances in Visual Studio 2010

We can easily create SharePoint 2010 List instances using visual studio 2010

Advantages:- 

• If there is no need of custom list in any other SiteCollection other than in one site, it is no meaning to create list definitions. Instead we can create one list instance and deploy it to site directly.

• After creating the new list instance we can add list data to Element file which will reduce the burden of creating list items every time that we deploy solution and even it will helps in the time of production site deployment.

Steps to Create:-

1. In visual studio 2010 click on File -> New project then new project window will open.
2. Then in Installed templates section of opened window select                     Visual C# ->SharePoint ->2010 -> then Empty SharePoint Project -> enter project name  -> then Ok - > Enter your site name and click on create. It will create project in visual studion.                                                                    
3. After this in Solution Explorer Right click on your project then click on Add -> New item.
4. Now in opened window select Online Templates -> List Instance and name your List then click on Add. 
5. Now new List instance is added to your folder.

SSRS 2008 R2 Export to Excel Hiding Columns

When I started working on SSRS in my learning days it took lot of my time to solve empty/hidden columns in excel after exporting from report.

Normally if you use only list control in your report without any other controls, we can export clean excel without any empty columns. But if there are any controls along with list control in your report, you have to concentrate more on alignment of each control to get proper excel export.

Hidden columns are result of small deviations in widths of controls.

For Example let us take one rectangle control for header and list control for users information in one Report as shown in Picture-1

Picture -1

Picture - 2

As shown in Picture 1, rectangle width is 1.0025 inches and list column width is 1.00 inches so because of 0.0025 difference in widths we will get column B as hidden in exported excel sheet as shown in Picture 2.

• To avoid hidden columns maintain widths with rounded values.
• If there are two or more controls above the list control, make sure each control is side by side and the width of each control is as integral multiple of list column width.