Friday, September 28, 2012

jQuery attribute with type and value NOT IN selector


The jQuery attribute with type and value NOT IN selector is used to filter out all elements in a page with a specific type, and have the specified attribute and NOT the specified value for the attribute, the syntax for this selector is.

$("input[type=<type name>][<attribute name> != <attribute value>]")

In this post we shall see on how to use the jQuery attribute with type and value NOT IN selector to select all text elements in a page which have the class attribute, and do not have a value of
RedText for the class attribute.

jQuery attribute with type and value IN selector


The jQuery attribute with type and value IN selector is used to filter out all elements in a page with a specific type, and have the specified attribute with the specified value for the attribute, the syntax for this selector is.

$("input[type=<type name>][<attribute name> = <attribute value>]")

In this post we shall see on how to use the jQuery attribute with type and value IN selector to select all text elements in a page which have the class attribute, and a value of
RedText for the class.

Thursday, September 27, 2012

jQuery attribute with type selector


The jQuery attribute with type selector is used to filter out all elements in a page with a specific type, and have the specified attribute, the syntax for this selector is.

$("input[type=<type name>][<attribute name>]")

In this post we shall see on how to use the jQuery attribute with type selector to select all text elements in a page which have the class attribute.

The following script lists out all the text elements in the page which have the attributeclass
 

jQuery attribute value selector


The jQuery attribute value selector is used to filter out all elements in a page which have the specified attribute and he specified value for the attribute, the syntax for this selector is.

$([attribute name = attribute value])

In this post we shall see on how to use the jQuery attribute value selector to select all elements in a page which have a specific attribute, with the specified value.

The following script lists out all the elements in the page which have the attributeborder”, and a value of 0 for the border attribute

jQuery attribute exists selector


The jQuery attribute exists selector is used to filter out all elements in a page which have the specified attribute, the syntax for this selector is.

$([attribute name])

In this post we shall see on how to use the jQuery attribute exists selector to select all elements in a page which have a specific attribute.

The following script lists out all the elements in the page which have the attributeborder

jQuery class selector


jquery, jquery selector, jquery attribute selector
The jQuery class selector is used to filter out all elements in a page with a specific class, the syntax for this selector is.

$(".className")

In this post we shall see on how to use the jQuery class selector to select all elements in a page which have a specific class.

The following script lists out all the elements in the page which have a classFocusText

jQuery id selector


The jQuery id selector is used to filter out all elements in a page with a specific ID, the syntax for this selector is.

$("#ID")

In this post we shall see on how to use the jQuery id selector to select all elements in a page which have a specific ID.

The following script lists out all the elements in the page which have an IDtxtName

jQuery attribute selector


The jQuery attribute selectors are used to select elements from a page based on the attributes of the element. For example the “#” selector will select elements based on the ID of the elements.

In this post we shall see the various attribute selectors available in jQuery, and how to use them to filter out elements of specific type.

The following are the attribute selectors available in jQuery.

Wednesday, September 26, 2012

jQuery type selector Example

In this post jQuery type selector Example, we shall see the various type selectors available in jQuery, and how to use them to filter out elements of specific type.

jQuery button selector


The jQuery button selector is used to filter out all the button elements in a page, the syntax for this selector is.

input[type="button"]


In this post we shall see on how to use the jQuery button selector to select all the button elements in a page without specifying the id or name of element explicitly.

The following script lists out all the button elements in the page

jQuery reset selector


The jQuery reset selector is used to filter out all the reset elements in a page, the syntax for this selector is.

input[type="reset"]


In this post we shall see on how to use the jQuery reset selector to select all the reset elements in a page without specifying the id or name of element explicitly.

The following script lists out all the reset elements in the page

jQuery submit selector


The jQuery submit selector is used to filter out all the submit elements in a page, the syntax for this selector is.

input[type="submit"]


In this post we shall see on how to use the jQuery submit selector to select all the submit elements in a page without specifying the id or name of element explicitly.

The following script lists out all the submit elements in the page

jQuery hyperlink selector


The jQuery hyperlink selector is used to filter out all the hyperlink elements in a page, the syntax for this selector is.

$('a')

In this post we shall see on how to use the jQuery hyperlink selector to select all the hyperlink elements in a page without specifying the id or name of element explicitly.

The following script lists out all the hyperlink elements in the page

jQuery image selector


The jQuery image selector is used to filter out all the image elements in a page, the syntax for this selector is.

$('image')

In this post we shall see on how to use the jQuery image selector to select all the image elements in a page without specifying the id or name of element explicitly.

The following script lists out all the image elements in the page

jQuery checkbox selector


The jQuery checkbox selector is used to filter out all the checkbox elements in a page, the syntax for this selector is.

input[type="checkbox"]


In this post we shall see on how to use the jQuery checkbox selector to select all the checkbox elements in a page without specifying the id or name of element explicitly.

The following script lists out all the checkbox elements in the page

jQuery radio selector


The jQuery radio selector is used to filter out all the radio elements in a page, the syntax for this selector is.

input[type="radio"]


In this post we shall see on how to use the jQuery radio selector to select all the radio elements in a page without specifying the id or name of element explicitly.

The following script lists out all the radio elements in the page

jQuery dropdown selector


The jQuery dropdown selector is used to filter out all the dropdown elements in a page, the syntax for this selector is.

$('select')

In this post we shall see on how to use the jQuery dropdown selector to select all the dropdown elements in a page without specifying the id or name of element explicitly.

The following script lists out all the dropdown elements in the page

jQuery password selector


The jQuery password selector is used to filter out all the password elements in a page, the syntax for this selector is.

input[type="password"]


In this post we shall see on how to use the jQuery password selector to select all the password elements in a page without specifying the id or name of element explicitly.

The following script lists out all the password elements in the page

jQuery hidden selector


The jQuery hidden selector is used to filter out all the hidden elements in a page, the syntax for this selector is.

input[type="hidden"]


In this post we shall see on how to use the jQuery hidden selector to select all the hidden elements in a page without specifying the id or name of element explicitly.

The following script lists out all the
hidden elements in the page

jQuery textarea selector


The jQuery textarea selector is used to filter out all the textarea elements in a page, the syntax for this selector is.

$('textarea')

In this post we shall see on how to use the jQuery textarea selector to select all the textarea elements in a page without specifying the id or name of element explicitly.

The following script lists out all the
textarea elements in the page

jQuery text selector


The jQuery text selector is used to filter out all the text box elements in a page, the syntax for this selector is.

input[type="text"]


In this post we shall see on how to use the jQuery text selector to select all the textbox elements in a page without specifying the id or name of element explicitly.

The following script lists out all the TextBox elements in the page

jQuery type selector.


The jQuery type selectors are used to select elements from a page based on the type of the element. For example the “:text” selector will select all the text boxes in the page.

In this post we shall see the various type selectors available in jQuery, and how to use them to filter out elements of specific type.

The following are the type selectors available in jQuery.

What is jQuery selector

jQuery offers a powerful set of selector operations, which can be used like wild cards to identify specific elements in a page. 

jQuery selectors can be used to identify elements
          Based on type (Textbox, Checkbox, etc…)
          Based on attributes (ID, class, Name, Title, etc…)
          Based on wildcards (Starts with, Ends with, contains, etc...)      
          Based on the state of the element (Enabled, Visible etc …)
          Based on the Hierarchy (First, Last, nth, Parent, Child etc …)

Saturday, September 22, 2012

Asp.Net jQuery href Example

The jQuery library provides various options to work with href links, in this post Asp.Net jQuery href Example, we shall see the various attributes and events of the Hyperlink control.

Asp.Net jQuery loop through all href controls in a Page


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery loop through all href controls in a Page, we shall see on how to loop through all the Hyperlink controls in a page using jQuery.

We can loop through all the Hyperlink controls in a page using jQuery as follows.

$('a').each(function() {
     alert('Link: ' + $(this).text());
});

Asp.Net jQuery href mouse hover Event Handler


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery href mouse hover Event handler, we shall see on how to capture the mouse hover event of a Hyperlink controls using jQuery.

We can handle the mouse hover event of a href control using jQuery as follows.

$('#lnkGoogle').hover(function() {
   alert("Hover on Link");
});

Asp.Net jQuery href click Event Handler


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery href click Event handler, we shall see on how to capture the click event of a Hyperlink controls using jQuery.

We can handle the click event of a href control using jQuery as follows.

$('#lnkGoogle').click(function(event) {
    alert("Link Clicked");
});

Asp.Net jQuery set href Target Attribute


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery set href Target Attribute, we shall see on how to set the Target Attribute of a Hyperlink control using jQuery.

We can set the Target Attribute of a href control using jQuery as follows.

$('#lnkGoogle').attr('target', '_self');

Asp.Net jQuery set href Text


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery set href Text, we shall see on how to set the Text of a Hyperlink control using jQuery.

We can set the Text of a href control using jQuery as follows.

$('#lnkGoogle').text('Gmail');

Asp.Net jQuery set href URL


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery set href URL, we shall see on how to set the URL of a Hyperlink control using jQuery.

We can set the URL of a href control using jQuery as follows.

$('#lnkGoogle').attr('href', 'http://www.gmail.com');

Asp.Net jQuery get Link Text


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery get href Link Text, we shall see on how to get the Text value of a href control.

We can get the Text value of a href control using jQuery as follows.

alert('TEXT: ' + $('#lnkGoogle').text());

Asp.Net jQuery get href target Attribute


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery get href target Attribute, we shall see on how to get the value of the target Attribute of a href control.

We can get the value of the target attribute of a href control using jQuery as follows.

alert('Attribute (target): ' + $('#lnkGoogle').attr('target'));

Asp.Net jQuery get href ID


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery get href ID, we shall see on how to get the ID of a href control.

We can get the ID of a href control using jQuery as follows.

alert($('#lnkGoogle').attr('id'));

Asp.Net jQuery get href link


The jQuery library provides various options to work with href links, in this post Asp.Net jQuery get href Link, we shall see on how to get the hyperlink value of a href control.

We can get the Hyperlink values of a href control using jQuery as follows.

alert($('#lnkGoogle').attr('href'));

Friday, September 14, 2012

InfoPath Forms Services - Enable Browser Compatible InfoPath forms

InfoPath forms created using Office InfoPath can be published as templates in the forms library. SharePoint 2007 InfoPath Forms Services supports opening InfoPath forms in Browser, but for this we need to make sure that the following settings are in place.

1. In the Central Administrator, make sure that the Browser enable features are checked.
Central Administration -> Application Management ->
InfoPath Forms Services -> Configure InfoPath Forms Services

What is InfoPath Forms Services?

InfoPath Forms Services is a new Feature available from SharePoint 2007, Forms Services enables us to create Form Libraries in SharePoint which can host InfoPath forms, developed using Office InfoPath.

InfoPath forms created using Office InfoPath can be published as templates in the forms library, InfoPath forms also support browser compatible version, which allows the users to open the published forms in browser, without the need to have Office InfoPath installed in all the end user computers.

What is Office InfoPath?

Collecting information from various stakeholders in a key activity in any business, InfoPath Forms helps in creating a streamlined and structured process for collecting information from various types of users and applications.

InfoPath forms can be published in Browser, Outlook, SharePoint Lists, etc, so it provides users various convenient ways to enter information, InfoPath forms are light weight forms which can be designed and published quickly, when compared to creating forms in applications like Asp.net or JSP.

InfoPath forms can be opened in 2 modes.

Tuesday, September 11, 2012

Key Performance Indicators

Key Performance Indicators

Reporting Services

Reporting Services

Excel Services - SharePoint Business Intelligence

Excel Services

Report Center - SharePoint Business Intelligence

Report Center

SharePoint Business Intelligence Overview

Business Intelligence Overview

Create KPI List from Excel Worksheet

KPI Lists are created to indicate the Goal Vs Actual status of critical Business parameters, multiple KPI's can be added to a single KPI List so that the status of all the critical parameters are captured in a single list.

In this post we shall see on how to create a KPI List based on the data in a Published Excel Sheet


First Create an Excel Workbook with the data which you want to represent in the KPI, I have created the following sheet.



Publish KPI List to Dashboards using KPI List Web Part

KPI Lists are used to display business critical parameters, with their goals and the current status, We can use the KPI List Web Part to display KPI Lists in Dashboards. KPI List Web Parts can also be configured to display multiple KPI Lists in the same Web part.
In this post we shall see on how to display a KPI List in a dashboard using a KPI List Web Part.

Create KPI List from SharePoint List

KPI Lists are created to indicate the Goal Vs Actual status of critical Business parameters, multiple KPI's can be added to a single KPI List so that the status of all the critical parameters are captured in a single list.

In this post we shall see on how to create a KPI List based on the data in a SharePoint List.

Type of Key Performance Indicators (KPI’s) in SharePoint


Key Performance Indicators (KPI’s) in SharePoint vary based on the datasource based on which they are created. SharePoint 2007 allows creating of KPI’s from the following data sources.

SharePoint Lists
The built in SharePoint Lists can be used as a data source to create KPI’s, these KPI’s read data from the SharePoint Lists and display the status in the KPI’s. When the data in the List gets updated the KPI’s display also gets updated automatically.

This type of KPI’s can be built for simple reports like Target vs. Actual sales.

Key Performance Indicators Overview

Key Performance Indicators (KPI) is a feature of SharePoint 2007 used to set and track goals. For example, KPI can be used to track sales targets, task completion status etc. KPI’s provide a visual representation of the current status of the variable under study.

The default KPI which comes with the default site of SharePoint 2007 looks as follows.


Monday, September 10, 2012

Publishing Reporting Services reports to SharePoint in Native Mode


Reporting Services reports can be published to SharePoint using 2 modes, Native and SharePoint Integration Mode, here we shall see on how to publish a Reporting Services Report to a SharePoint Page in the Native mode.

Publishing Reporting Services reports to SharePoint in SharePoint Integration mode


Reporting Services reports can be published to SharePoint using 2 modes, Native and SharePoint Integration Mode, here we shall see on how to publish a Reporting Services Report to a SharePoint Library in the SharePoint Integration mode.

Configure Reporting Services SharePoint Integration Mode

Reporting Services reports can be published to SharePoint using 2 modes, Native and SharePoint Integration Mode, here we shall see on how to configure the Reporting Services to SharePoint integration mode so that the reports created in the Reporting Center can be published directly to SharePoint Libraries.

Integrating SQL Server Reporting Services with SharePoint


The SQL Server Reporting service can be integrated with SharePoint to display the Reporting services reports in SharePoint pages and dashboards.

Integration Modes
The Reporting Services can be configured to work with SharePoint in 2 modes Native & Share Point Integration Mode.

Native Mode: In the Native mode, the reports are created, stored and processed in the         reporting server itself, to display these reports in SharePoint we can use the Reporting Services          web parts, provide the URL of the
Report Manager instance and the actual Report to be displayed, and           the report will get displayed in the Web part.

Share Point Integration Mode: In this mode, the reports created in the reporting server    can be published to a SharePoint Library, which is configured during setting up the integration          mode. Provide access rights to the report using SharePoint Security Model.

Integrates with WSS 3.0 Also

Windows SharePoint Server 3.0 does not have the Reporting Center and Dashboard features. By integrating Reporting Services with WSS 3.0 we can create our own dashboard like pages and display reporting services reports using the Reporting Services web parts.

Reporting Services in SharePoint

Reporting services also called SSRS (SQL Server Reporting Services) is a Reporting tool which comes packed with SQL Server. It is a server-based reporting platform, which produces a variety of reports based on different data sources.

The Reports created using Reporting Services can be integrated with SharePoint and can be displayed in SharePoint pages / web parts.

Wednesday, September 5, 2012

Changing cell value of a Published Excel Workbook using Excel Web services

Excel Web Services can be used to update data to Published Excel Work Sheets, in this post is will go through the steps to update data programatically using Excel Web Services, to a Published Excel worksheet. 

Reading data from a Published Excel Workbook using Excel Web services

Excel Web Services can be used to query data from Published Excel Work Sheets, in this post is will go through the steps to read data programatically using Excel Web Services, from a Published Excel worksheet. 

Excel Web Services


Excel Web Services are a set of Web Service APIs which can be used by developers to access published Excel workbooks, read data from the workbooks, updated data to the workbooks etc.

The Excel Web Services provide a Session object which should be used to make successive calls to the web services, so that SharePoint will be able to identify all requests which come from a single application/service. This Session ID should be passed with all requests which are made from the current connection to maintain state.

Publishing Excel Worksheets using Excel Service

Excel Work Books and individual Excel sheets can be published in SharePoint server, once Published the sheets can be viewed by other users in their Browser, they need not have MS Office Installed in their PC.

To Publish an Excel WorkBook in a SharePoint server use the following Steps.

Components of Excel Services

The following are the basic components to Excel Services

Excel Services in SharePoint


Excel Services allows us to publish excel worksheets and workbooks in the SharePoint server, the files are uploaded to the server and other users can view the published worksheets in their browser. The Excel Web Access (EWA) Web Part enables to users to view the published sheets in the browser.

Excel services enables users to update the information in the published sheets and maintains versioning of the sheets using check-in/check-out.

Monday, September 3, 2012

Report Center – Data Connection Library

The Report Center has a Data Connection Library which can be used to store connection information which can be used by the report center to access data from other internal and external sources.


The Data Connection Library, can store two types of connection information.

Office Data Connection files: These files have an extension of .odc, they are used by Office Applications to store information which can be used to locate, log on, query, and access data from external data sources.


Universal Data Connection files These are file with extension .udc, they are used by Applications like InfoPath to locate, log on, query, and access data from external data source.  These are XML based XML files with a particular namespace and schema.  Supports Single Sign-On (SSO) for applications in multi-tier architectures. Unlike the ODC format used by other Microsoft Office applications, which stores information about database connections, UDC files can store information about several different types of data connections, and they can be extended to store information about arbitrary types.

The Data Connection Library in Share point 2007 looks as follows.