Showing posts with label Filter. Show all posts
Showing posts with label Filter. Show all posts

Monday, 15 August 2011

CSharp.Net SharePoint List of Document Libraries using Client Context


This code will only return Document Libraries which are based on Template 101 ancestral type.


ClientContext clientContext = new ClientContext("http://mysharepoint");
Web oWebsite = clientContext.Web;
ListCollection collList = oWebsite.Lists;
clientContext.Load(collList);
clientContext.ExecuteQuery();
foreach (List oList in collList)
{
if ((oList.BaseType == BaseType.DocumentLibrary) && (oList.BaseTemplate == 101))
   {
     Do your actions here with oList.Title, oList.Title
   }
}

Thursday, 5 May 2011

SSRS 2008 Report String Filter with LIKE operator

goto the Filters in Tablix or Group,
Add the filter,
select Expression as your Fieldname to be filtered on,
select operator LIKE
in value when you click fx button it will show you options in new window
click parameters and select the parameter you created in the report.
you'll see =Parameters!ParameterName.Value
change that to = "*" & Parameters!ParameterName.Value & "*"