SSRS: Parameter YYYY/MM/DD format

SSRS: Parameter YYYY/MM/DD format

=Year(CDATE(Parameters!FromDate.Value))&"-"&Month(CDATE(Parameters!FromDate.Value))&"-"&Day(CDATE(Parameters!FromDate.Value))

=Year(CDATE(Parameters!ToDate.Value))&"-"&Month(CDATE(Parameters!ToDate.Value))&"-"&Day(CDATE(Parameters!ToDate.Value))

SSRS Report Split URL: Legend Set Expression:

Split URL: Legend Set Expression:

=Split(Fields!ID.Value, "/").GetValue(Split(Fields!ID.Value, "/").Length - 1) –Splits last one

=Split(Fields!ID.Value, "/").GetValue(1)—Splits first one

Display Link Lists in the SharePoint 2013 Content Query Web Part

Display Link Lists in the SharePoint 2013 Content Query Web Part

StyleLibrary: Itemstyle. xsl

<xsl:template name="LinkList" match="Row[@Style='LinkList']" mode="itemstyle">
     <xsl:variable name="SafeLinkUrl">
         <xsl:call-template name="OuterTemplate.GetSafeLink">
             <xsl:with-param name="UrlColumnName" select="@URL"/>
         </xsl:call-template>
     </xsl:variable>
     <xsl:variable name="DisplayTitle">
         <xsl:call-template name="OuterTemplate.GetTitle">
             <xsl:with-param name="Title" select="@URL"/>
             <xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>
         </xsl:call-template>
     </xsl:variable>
     <xsl:variable name="TheLink">
<xsl:value-of select="substring-before($DisplayTitle,',')"/>
     </xsl:variable>
     <div id="linkitem">
         <xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>
         <a href="{$TheLink}" target="_blank" title="This link opens in a new window">
         <xsl:value-of select="substring-after($DisplayTitle,',')"/>
         </a>
     </div>
 </xsl:template>

Copy/Fetch Multi line field-Append changes to Existing Text to Another field

Copy/Fetch Multi line field-Append changes to Existing Text to Another file.

// string key= Field data which your capturing

static void Main(string[] args)



{
  SPSecurity.RunWithElevatedPrivileges(delegate()



{
  using (SPSite site = new SPSite("SiteUrl"))



{
  using (SPWeb web = site.OpenWeb())



{
  SPList list = web.Lists.TryGetList("TestRKU");

if (list != null)



{
  SPListItemCollection itemColl = list.Items;

foreach (SPListItem item in itemColl)



{
  GetVersionedMultiLineTextAsPlainText(item, "MultiSource");





}

}

}

}

});

}
  public static void GetVersionedMultiLineTextAsPlainText(SPListItem item, string key)



{
  StringBuilder sb = new StringBuilder();

foreach (SPListItemVersion version in item.Web.Lists[item.ParentList.ID].Items[item.UniqueId].Versions)



{
  SPFieldMultiLineText field = version.Fields[key] as SPFieldMultiLineText;

if (field != null)



{
  string comment = field.GetFieldValueAsText(version[key]);

if (comment != null && comment.Trim() != string.Empty)



{
  sb.Append("");

sb.Append(version.CreatedBy.User.Name).Append(" (");

sb.Append(version.Created.ToString("MM/dd/yyyy hh:mm tt"));

sb.Append(") ");



sb.Append(comment);

}

}

}
  item["Destination"] = sb.ToString();



item.SystemUpdate();

}