Posts

Showing posts from May, 2011

REPORTING SERVICE IN SHAREPOINT 2010

Image
Step one: Open SQL Server Business Intelligence Development Studio
Step two: Click new add new project and add Report Server Project.



















Step Three: Right Click on Shared Data Source and click Add New Data source to add connection.



Step four: In General tab add the Name for the Data Source Select Type as XML Add connection String as http://Site/_layouts/_vti_bin/Lists.asmx





















Step five: In Credentials tab select the Integrated Security...





















Step six: Right click on Reports and Click on Add New Report
























Step Seven: Give the Report name and click next. Then type the Query String code as given below…
<Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>{LIST GUID}</DefaultValue> </Parameter> </Parameters> </Method> <ElementPath IgnoreName…

Remove hyperlink for lookup columns in SharePoint

SharePoint Development Tasks - How Do I...?

Image

SharePoint Interview Questions

Installing and Configuring Windows Server 2008 SMTP

To see how to configure SMTP Server for Windows Server 2008

Click here

Access the site from external system

Central Admin
System Settings
Farm Management
Configure alternate Access Mappings
Add internal url
Alternate Access Mapping Collection : Select the web application here
Add internal url : Type Domanin Name or ip address
Also can select the Zone for the that... Like intranet,internet


Calculated Column Condition in SharePoint

For creating a calculated column that is dependent on the other column which is in the same list , we can create in the browser itself. No need for the Sharepoint Designer.

STEP ONE:
Create a Column for Calculated List...
STEP TWO:
Identify the list which we have to lookup for calculation...
STEP THREE:
Syntax is
=IF([Column Name]="Condition one","Set this value one",IF([Column Name]="Condition Two","Set this value two"))
Like this we can add N conditions...

Add Dynamic Hyperlink To List Column By SharePoint Workflow

Image
We Always come across in need to add a hyperlink which should be changing the link dynamically .For this , This post will be helpful...!

Step 1: Add the column and select type as Hyperlink:












Step 2: Then open SharePoint Designer and create the workflow for the associated list.
Step 3: Add local variable as string in workflow. 



























Step 4: Then Set Workflow variable… In that select the variable and select the link.






Step 5: Then Update the list Column (Case Details) with this url variable ….























Step 6: Then Save and publish the workflow. Now a dynamic link is created.

ADD CUSTOM NAVIGATION MENU IN SHAREPOINT MASTER PAGE:

Image
1. To find the images use the following links
http://www.tabsgenerator.com/?page=index http://www.storm-consultancy.com/blog/tools/TabCreator/ http://www.yellowpipe.com/yis/tools/hex-to-rgb/color-converter.php

2. Add the following script in the master page … In between the </Body>  and  </html>
<script type="text/javascript"> OnLoading(); </script>
3. Add following script inside the HEAD section of master page…!
<script type="text/javascript"> function display(tdval, status) { var td = "td"+tdval;    var val = document.getElementById("hid_id").value;
if(val != td) {
if(status == 'yes') { document.getElementById(td).style.backgroundImage = "url('/sites/tkg/siteassets/images/newtab_on.gif')"; }    else if( status == 'no') { document.getElementById(td).style.backgroundImage = "url('/sites/tkg/SiteAssets/Images/newtab_off.gif')";
}                 }                 }
function OnLoading() { …