Posts

Use Lists Web Server to get data in the SSRS 2008 R2 Reports

Image
Step 1: Ensure that you have a SharePoint List. In this demo, we will report against SharePoint Products List. Step 2: Understand the SharePoint List Web Service Interface. SharePoint has a lists.asmx web service which provides interface to download the SharePoint lists data in the non-SharePoint systems. You can access the SharePoint list web service using the  http://siteurl/_vti_bin/lists.asmx . You can use the GetListItems method which returns dataset to download all the list items for the specific list. Step 3: Create new Shared Data Source and Report Server Project Create a new Report Server Project in the Business Intelligence Development Studio (BIDS). First step of configuring the SSRS report is creating the new shared data source. Select the SharePoint List as a data source type and specify the SharePoint Site URL hosting the lists for the connection string. On the credentials tab, specify either windows authentication or no authentication if anonymous authenticatio

Implement Live Chat in Sharepoint

Image
This feature of the Windows Live Messenger application enables you to actually add a web-based messenger to your site or blog. Check out http://settings.messenger.live.com/applications/websettings.aspx to create one for yourself. I will explain in brief. Here http://settings.messenger.live.com/applications/WebSettings.aspx you will see a setting for "Show your Messenger Status on the Web" The checkbox "Allow websites to see your Messenger status and send you messages" will allow any one to message you from the gadget. You can place the gadget on any web page by copying the html code. To get the HTML code click here http://settings.messenger.live.com/applications/CreateHtml.aspx At the bottom you will find these instructions. "Copy the HTML and paste it into your webpage" Open your sharepoint page in browser. Drag and Place a ContentEditorWebPart there. In it's Source Editor, Past the HTML Code that you have copied. That's It. Dude now people can c

SharePoint 2010 CSS Chart

Image
CSS Comments Screenshots body #s4-ribboncont{background-image:none;} /*Globally turning off bordersThis is needed to have any of the style below to take effect.   .ms-cui-groupSeparator {border-right:1px solid #E7E7E8 !important; } .ms-cui-topBar2{border-width:0px;}*/ /*Turn on separators in the Ribbon   .ms-cui-ribbonTopBars{ background: red url() repeat-x !important; padding-top:0px; } /* Set the background for the tabs at the top (Browse / Page) */ .ms-cui-cg-i{ background-image:url() !important; background-position:bottom left; background-repeat:no-repeat !important; height:15px; margin-bottom:2px; } .ms-cui-cg-db .ms-cui-cg-t{height:17px; background-image:url(‘http://integration.echn.ca/Media/SiteImages/bgBackground.gif’) !important; background-position:bottom right !important; background-repeat:no-repeat !important; margin-left:4px;} .ms-cui-cg-t-i{ color:white; font-weight:bold; } .ribbon-wrapper{position:relative;} /* Set the background for the addi

Auto Fill Title of Document in SharePoint 2010

Download Auto Fill Title Setup Hi All,   When an end user works with Document Library in SharePoint, the user faces a problem while uploading a new document. user has to fill “Title” field of Document Library. The user has to type value in title field or just copy and paste document name in title field. Some time this job irritating to the users. I am also facing this kind of problem. So I searched over internet and I found some solutions for this problem and which are paid solution. I thought why not I should create a free solution which can solve this problem. So Here I am with a solution which Automatically Fills Title when you upload a document into Document Library. Installation Instructions: I have provided an installation setup. You need to run setup application file from setup folder. You need to select the site collection where you want to deploy this solution. After deployment you need to check that Solution Feature has activated or not. So go to Site Setting of yo

Infopath Code

Here are some important codes for InfoPath.  Get Parameters in InfoPath Form: if (e.InputParameters.ContainsKey( "SaveLocation" )) // Search for Query string (parameter) if found then set this parameter to a field.                     SetFormFieldValue ( "/my:ChangeOrder/my:SectionHide/my:ListURL" , e.InputParameters[ "SaveLocation" ].Substring(0, e.InputParameters[ "SaveLocation" ].LastIndexOf( "/" ))); Get Value from a field: private string GetFormFieldValue( string fieldName)         {             string fieldValue = string .Empty;             try             {                 XPathNavigator myNav = MainDataSource.CreateNavigator().SelectSingleNode(fieldName, NamespaceManager);                 if (myNav != null )                     fieldValue = myNav.Value; ;                 if ( string .IsNullOrEmpty(fieldValue))                     return string .Empty;                 else                     return fieldValue;   

Download Infopath Form Templates

Click here to download InfoPath Form Collection   Hi, I have lots of InfoPath forms with me which are downloaded from lots of places. I am uploading this InfoPath form collection for all InfoPath and SharePoint Users. These form are related to Infopath 2003, 2007 & 2010.   Click here to download InfoPath Form Collection

Free Charts for SharePoint 2010

Here we are again with something new and exciting… I am sure this is going to help all the BI professionals who are frustrated and irritated of using SharePoint default chart web parts and certain limitations in it. Let me share with you’ll a free source of chart web part developed using Google’s API and provides very interactive , easy to use and colorful charting experience. This is been awarded as the best free chat web part of the year. You can easily connect these web parts with SharePoint list and show the data in different chart types like: ·          Pie ·          Pie3D ·          Vertical Bar ·          Vertical Stacked Bar ·          Horizontal Bar ·          Horizontal Stacked Bar……and many more… It also supports all the various Google Parameters, Please refer to the official Google API parameter information for more detailed knowledge. Please click here to download Free Google web part and deployment instruction & Hexadecimal Color Codes list is here . I hope you

Cross Site List Rollup Web Part for SharePoint 2010

Downalod Cross Site List Rollup   Hi I was wondering that how to show a list from other site on my home page. But I didn’t get any proper & free solution. So I decided to create a Cross Site List Rollup Webpart . Now I have developed a Cross site list rollup web part which can show your list from any site to any site (within site collation only) and I am ready to share this web part with all of you.  It’s too simple in use. You have to just provide a:    Site URL (Site URL from where you want to display list or library).    List Title (Display Name of List) (Title of the list which has to be on given site URL).    View Name (Name of view which you have created to show in this web part). Now it is ready to use. Enjoy!!! Downalod Cross Site List Rollup Gaurav Goyal

SharePoint 2010 Visual How Tos by Microsoft

( http://msdn.microsoft.com/en-us/library/ff598601.aspx ) v   Accessing SharePoint 2010 Data with the .NET Client Object Model v   Accessing SharePoint 2010 Data with the Silverlight Client Object Model v   Accessing SharePoint 2010 List Data by Using LINQ to SharePoint v   Accessing SharePoint 2010 Lists by Using WCF Data Services v   Adding Overlays to Drawings in Visio Services in SharePoint Server 2010 v   Adding SharePoint Project Items to SharePoint Projects in Visual Studio 2010 v   Calling Public Web Services from a Sandboxed Silverlight Application in SharePoint 2010 v   Creating an Excel Services and Bing Maps Mashup for SharePoint 2010 Using the Excel Services ECMAScript Object Model v   Creating Content Types for SharePoint 2010 in Visual Studio 2010 v   Creating Custom Extensions for SharePoint 2010 Development Tools in Visual Studio 2010 v   Creating Custom SharePoint 2010 Field Types v   Creating Custom SharePoint 2010 Service Applications and Consumers v   C