namespace MyDocLibraryBreadcrumb
{
    public class MyDocLibBreadcrumbDelegateControl : WebControl 
    {
        protected override void OnPreRender(EventArgs e)
        {
 
            try
            {
                base.OnPreRender(e);
 
                // Get the path to the current folder
                string path = Context.Request.QueryString["RootFolder"];
 
                // if there's no path then there is nothing to do; it implies are are not in the context of the library 
                if (String.IsNullOrEmpty(path))
                {
                    return;
                }
 
                // Let's get the current folder
                SPWeb web = SPContext.Current.Web;
                SPFolder currentFolder = web.GetFolder(path);
 
                // Let's find the breadcrumb control on the current page - it's a ListProperty control where the property is  "TitleBreadcrumb". 
                Control c = Utils.FindRecursive(Page.Controls, ctrl => ctrl is ListProperty && ((ListProperty)ctrl).Property == "TitleBreadcrumb");
 
                // If not found, nothing to do, and we are not likely in a library. 
                if (c == null)
                    return;
 
                // Let's subsitute the OOTB breadcrumb control with our replacement enhanced one
                var parent = c.Parent;
                var index = parent.Controls.IndexOf(c);
                parent.Controls.RemoveAt(index);
                parent.Controls.AddAt(index, new LiteralControl { Text = GetReplacementBreadCrumbOutput(currentFolder) });
            }
            catch (Exception ex)
            {
                // log errors quietly 
                Utils.WriteMyLog(Utils.GetErrorInfo(ex));
            }
        }
 
 
        /// SPFolder is the parameter to create navigation to
        /// returns the HTML output
        private string GetReplacementBreadCrumbOutput(SPFolder folder)
        {
            List<BreadcrumbNodeData> nodes = new List<BreadcrumbNodeData>();
 
            // Collect a path from current folder to its root folder
            SPFolder nodeFolder = folder;
            while (nodeFolder != null)
            {
                // If we're in folder use the folder name as a title. If not use a library title enstead.
                BreadcrumbNodeData node  = new BreadcrumbNodeData();
                node.Url = nodeFolder.ServerRelativeUrl;
                if (string.IsNullOrEmpty(nodeFolder.ParentFolder.Url))
                {
                    if (nodeFolder.DocumentLibrary != null)
                        nodes.Add(new BreadcrumbNodeData
                                      {Title = nodeFolder.DocumentLibrary.Title, Url = nodeFolder.ServerRelativeUrl});
                }
                else
                {
                    nodes.Add(new BreadcrumbNodeData { Title = nodeFolder.Name, Url = nodeFolder.ServerRelativeUrl });
                }
 
                nodeFolder = string.IsNullOrEmpty(nodeFolder.ParentFolder.Url) ? null : nodeFolder.ParentFolder;
            }
 
            // Reverse the collected path because the root folder must be on the left in bredcrumb
            nodes.Reverse();
 
            // Create an HTML output similar to original. An arrow image we've created from the original
            string htmlOutput = String.Empty;
 
            foreach (var node in nodes)
            {
                if (node != nodes.Last())
                    htmlOutput +=
                        String.Format(
                            @"<A href=""{0}"">{1}</A> <IMG style=""vertical-align:middle"" alt=: src=""/_layouts/images/MyDocLibraryBreadcrumb/breadcrumb_arrow.png""/> ", node.Url, node.Title);
                else
                {
                    htmlOutput += node.Title;
                }
            }
 
            return htmlOutput;
        }
    }
 
 
    /// temporary class to holds navigation node data
 
    public class BreadcrumbNodeData
    {
        /// Title for URL (it will be a folder name)
        public string Title { get; set; }
 
        /// Url to navigate on click (it will be a server relative URL of the folder)
        public string Url { get; set; }
    }
 
    public class Utils
    {
        public static string GetErrorInfo(Exception ex)
        {
            string result = "ex.Message=" + ex.Message;
            result += ex.InnerException == null ? "|ex.StackTrace=" + ex.StackTrace : String.Empty;
 
            if (ex.InnerException != null)
                result += "[INNER EXCEPTION: ]" + GetErrorInfo(ex.InnerException);
 
            return result;
        }
 
        public static void WriteMyLog(string text)
        {
            SPDiagnosticsService.Local.WriteTrace(0,
                                                  new SPDiagnosticsCategory("MyDocLibBreadcrumbDelegateControl", TraceSeverity.High,
                                                                            EventSeverity.Error),
                                                  TraceSeverity.High, text, null);
        }
 
 
 
        /// Finds a control based on provided criteria inside controls hierarchy
 
        /// <param name="controls">A Controls collection to start search</param>
        /// <param name="criteria">A criteria to return control</param>
        /// <returns>The founded control </returns>
        public static Control FindRecursive(ControlCollection controls, Func<Control, bool> criteria)
        {
            foreach (Control control in controls)
            {
                if (criteria(control))
                    return control;
 
                var innerControl = FindRecursive(control.Controls, criteria);
                if (innerControl != null)
                    return innerControl;
            }
 
            return null;
        }
    }
}

namespace MyDocLibraryBreadcrumb { public class MyDocLibBreadcrumbDelegateControl : WebControl { protected override void OnPreRender(EventArgs e) { try { base.OnPreRender(e); // Get the path to the current folder string path = Context.Request.QueryString["RootFolder"]; // if there's no path then there is nothing to do; it implies are are not in the context of the library if (String.IsNullOrEmpty(path)) { return; } // Let's get the current folder SPWeb web = SPContext.Current.Web; SPFolder currentFolder = web.GetFolder(path); // Let's find the breadcrumb control on the current page - it's a ListProperty control where the property is "TitleBreadcrumb". Control c = Utils.FindRecursive(Page.Controls, ctrl => ctrl is ListProperty && ((ListProperty)ctrl).Property == "TitleBreadcrumb"); // If not found, nothing to do, and we are not likely in a library. if (c == null) return; // Let's subsitute the OOTB breadcrumb control with our replacement enhanced one var parent = c.Parent; var index = parent.Controls.IndexOf(c); parent.Controls.RemoveAt(index); parent.Controls.AddAt(index, new LiteralControl { Text = GetReplacementBreadCrumbOutput(currentFolder) }); } catch (Exception ex) { // log errors quietly Utils.WriteMyLog(Utils.GetErrorInfo(ex)); } } /// SPFolder is the parameter to create navigation to /// returns the HTML output private string GetReplacementBreadCrumbOutput(SPFolder folder) { List<BreadcrumbNodeData> nodes = new List<BreadcrumbNodeData>(); // Collect a path from current folder to its root folder SPFolder nodeFolder = folder; while (nodeFolder != null) { // If we're in folder use the folder name as a title. If not use a library title enstead. BreadcrumbNodeData node = new BreadcrumbNodeData(); node.Url = nodeFolder.ServerRelativeUrl; if (string.IsNullOrEmpty(nodeFolder.ParentFolder.Url)) { if (nodeFolder.DocumentLibrary != null) nodes.Add(new BreadcrumbNodeData {Title = nodeFolder.DocumentLibrary.Title, Url = nodeFolder.ServerRelativeUrl}); } else { nodes.Add(new BreadcrumbNodeData { Title = nodeFolder.Name, Url = nodeFolder.ServerRelativeUrl }); } nodeFolder = string.IsNullOrEmpty(nodeFolder.ParentFolder.Url) ? null : nodeFolder.ParentFolder; } // Reverse the collected path because the root folder must be on the left in bredcrumb nodes.Reverse(); // Create an HTML output similar to original. An arrow image we've created from the original string htmlOutput = String.Empty; foreach (var node in nodes) { if (node != nodes.Last()) htmlOutput += String.Format( @"<A href=""{0}"">{1}</A> <IMG style=""vertical-align:middle"" alt=: src=""/_layouts/images/MyDocLibraryBreadcrumb/breadcrumb_arrow.png""/> ", node.Url, node.Title); else { htmlOutput += node.Title; } } return htmlOutput; } } /// temporary class to holds navigation node data public class BreadcrumbNodeData { /// Title for URL (it will be a folder name) public string Title { get; set; } /// Url to navigate on click (it will be a server relative URL of the folder) public string Url { get; set; } } public class Utils { public static string GetErrorInfo(Exception ex) { string result = "ex.Message=" + ex.Message; result += ex.InnerException == null ? "|ex.StackTrace=" + ex.StackTrace : String.Empty; if (ex.InnerException != null) result += "[INNER EXCEPTION: ]" + GetErrorInfo(ex.InnerException); return result; } public static void WriteMyLog(string text) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("MyDocLibBreadcrumbDelegateControl", TraceSeverity.High, EventSeverity.Error), TraceSeverity.High, text, null); } /// Finds a control based on provided criteria inside controls hierarchy /// <param name="controls">A Controls collection to start search</param> /// <param name="criteria">A criteria to return control</param> /// <returns>The founded control </returns> public static Control FindRecursive(ControlCollection controls, Func<Control, bool> criteria) { foreach (Control control in controls) { if (criteria(control)) return control; var innerControl = FindRecursive(control.Controls, criteria); if (innerControl != null) return innerControl; } return null; } } }

where TaskIsSummary=0

where TaskIsSummary=0

where TaskIsSummary=0 and TaskIsExternal = 0

where TaskIsSummary=0 and TaskIsExternal = 0

, case
 when [MSP_EpmProject_UserView].[Budgeted Costs] = 0 THEN 0
 when MSP_EpmTask_UserView.TaskRegularWork = 0 THEN 0
 when MSP_EpmProject_UserView.ProjectWork = 0 THEN 0
 else
 [MSP_EpmProject_UserView].[Budgeted Costs] * ( MSP_EpmTask_UserView.TaskRegularWork/ MSP_EpmProject_UserView.ProjectWork )
 END as [Budgeted Costs]
 
FROM dbo.MSP_EpmProject_UserView INNER JOIN dbo.MSP_EpmTask_UserView
ON MSP_EpmProject_UserView.ProjectUID = MSP_EpmTask_UserView.ProjectUID
where TaskIsSummary=0 and TaskIsExternal = 0
ORDER BY MSP_EpmProject_UserView.ProjectName, MSP_EpmTask_UserView.TaskIndex, MSP_EpmTask_UserView.TaskName

, case when [MSP_EpmProject_UserView].[Budgeted Costs] = 0 THEN 0 when MSP_EpmTask_UserView.TaskRegularWork = 0 THEN 0 when MSP_EpmProject_UserView.ProjectWork = 0 THEN 0 else [MSP_EpmProject_UserView].[Budgeted Costs] * ( MSP_EpmTask_UserView.TaskRegularWork/ MSP_EpmProject_UserView.ProjectWork ) END as [Budgeted Costs] FROM dbo.MSP_EpmProject_UserView INNER JOIN dbo.MSP_EpmTask_UserView ON MSP_EpmProject_UserView.ProjectUID = MSP_EpmTask_UserView.ProjectUID where TaskIsSummary=0 and TaskIsExternal = 0 ORDER BY MSP_EpmProject_UserView.ProjectName, MSP_EpmTask_UserView.TaskIndex, MSP_EpmTask_UserView.TaskName

, case
 when [MSP_EpmProject_UserView].[Budgeted Costs] = 0 THEN 0
 when MSP_EpmAssignment_UserView.AssignmentWork = 0 THEN 0
 when MSP_EpmProject_UserView.ProjectWork = 0 THEN 0
 else
 [MSP_EpmProject_UserView].[Budgeted Costs] * ( MSP_EpmAssignment_UserView.AssignmentWork/ MSP_EpmProject_UserView.ProjectWork )
 END as [Budgeted Costs]
 
,[MSP_EpmResource_UserView].[Cost Type]
 
,[MSP_EpmResource_UserView].[Resource Departments]
 ,[MSP_EpmResource_UserView].[RBS]
 ,[MSP_EpmResource_UserView].[Resource Title] FROM dbo.MSP_EpmProject_UserView INNER JOIN dbo.MSP_EpmTask_UserView ON MSP_EpmProject_UserView.ProjectUID = MSP_EpmTask_UserView.ProjectUID LEFT OUTER JOIN dbo.MSP_EpmAssignment_UserView ON MSP_EpmTask_UserView.TaskUID = MSP_EpmAssignment_UserView.TaskUID AND MSP_EpmTask_UserView.ProjectUID = MSP_EpmAssignment_UserView.ProjectUID LEFT OUTER JOIN dbo.MSP_EpmResource_UserView ON MSP_EpmAssignment_UserView.ResourceUID = MSP_EpmResource_UserView.ResourceUID
where TaskIsSummary=0 and TaskIsExternal = 0
ORDER BY MSP_EpmProject_UserView.ProjectName, MSP_EpmTask_UserView.TaskIndex, MSP_EpmTask_UserView.TaskName

, case when [MSP_EpmProject_UserView].[Budgeted Costs] = 0 THEN 0 when MSP_EpmAssignment_UserView.AssignmentWork = 0 THEN 0 when MSP_EpmProject_UserView.ProjectWork = 0 THEN 0 else [MSP_EpmProject_UserView].[Budgeted Costs] * ( MSP_EpmAssignment_UserView.AssignmentWork/ MSP_EpmProject_UserView.ProjectWork ) END as [Budgeted Costs] ,[MSP_EpmResource_UserView].[Cost Type] ,[MSP_EpmResource_UserView].[Resource Departments] ,[MSP_EpmResource_UserView].[RBS] ,[MSP_EpmResource_UserView].[Resource Title] FROM dbo.MSP_EpmProject_UserView INNER JOIN dbo.MSP_EpmTask_UserView ON MSP_EpmProject_UserView.ProjectUID = MSP_EpmTask_UserView.ProjectUID LEFT OUTER JOIN dbo.MSP_EpmAssignment_UserView ON MSP_EpmTask_UserView.TaskUID = MSP_EpmAssignment_UserView.TaskUID AND MSP_EpmTask_UserView.ProjectUID = MSP_EpmAssignment_UserView.ProjectUID LEFT OUTER JOIN dbo.MSP_EpmResource_UserView ON MSP_EpmAssignment_UserView.ResourceUID = MSP_EpmResource_UserView.ResourceUID where TaskIsSummary=0 and TaskIsExternal = 0 ORDER BY MSP_EpmProject_UserView.ProjectName, MSP_EpmTask_UserView.TaskIndex, MSP_EpmTask_UserView.TaskName