Thursday, December 29, 2016

Tried creating a new variation label source site and got an error (with correlation id) when trying to access "Variation Labels" under Site Settings


OK! This one is a very strange error that  I encountered while setting up Translation sites in Office 365. While setting up a new source Translation Label site, the site was successfully provisioned but when I tried to access "Variation Labels" under Site Settings - got an Error page with correlation ID.



Upon further digging around, I found the culprit, a hidden library called "Variation Labels" where one of the columns "Title" should actually have a display name of "Label" but instead was still called "Title". If you enabled Publishing Feature on your Site Collection or created a Publishing Site you should be able to navigate to this library using  a URL like https://<your site collection URL>//Variation%20Labels/ - once you are in this library, click on Library Settings and ensure the Display Name of the "Title" column is "Label" (if not click on the column name and update the display name). Basically the different columns in this library should look like below:



Now try accessing "Variation Labels" under Site Settings and VOILA! there will be no exception and you will be able to see your variation label source site listed there.

Saturday, December 24, 2016

How to fix SSRS Page Count issue Page 1 of 2 ? where the page count is missing for some bizzare reason


SSRS Page Count issue "Page 1 of 2 ?", where the page count is missing is really due to a feature that was included since SQL Server 2008 Reporting Services called "On Demand Processing", which renders one page at a time to handle load and improve performance (especially for large reports)


You can fix this issue easily by adding a textbox to the report footer, set the textbox properties to "Hidden=true". Now set the textbox expression to "=Globals!TotalPages" (don't use quotes).

Voila!! Just like that when you refresh / re-run your report, it should now show the total number of pages in the SSRS report action bar

Thursday, November 03, 2016

How to resolve the "Loading" screen issue that constantly shows while using "Add an App" in sharepoint2013 (especially if you have built your own custom master page).

STEP 1) Ensure you add "DeltaPlaceHolderPageTitleInTitleArea" and "DeltaPlaceHolderLeftNavBar" to the tag below in Master page
<!--SPM:<SharePoint:SPClientIDGenerator runat="server" ServerControlID="DeltaPlaceHolderMain;DeltaPlaceHolderPageTitleInTitleArea;DeltaPlaceHolderUtilityContent;DeltaPlaceHolderLeftNavBar"/>-->


STEP 2) Add a Div hidden snippet just above the footer or at bottom of master page before the </body> end tag, with the following controls (cross check whether the following controls are not already present on the Master page - HINT: Find by the id name - if they exist dont re-add them)
   
<div style="display:none;">
 <!-- remove start and end tags below for DeltaPlaceHolderLeftNavBar and PlaceHolderLeftNavBar if already exists in master page -->
 <!--SPM:<SharePoint:AjaxDelta id="DeltaPlaceHolderLeftNavBar" BlockElement="true" CssClass="ms-core-navigation" role="navigation" runat="server">-->
 <!--SPM:<asp:ContentPlaceHolder id="PlaceHolderLeftNavBar" runat="server">-->
 <!--SPM:</asp:ContentPlaceHolder>-->
 <!--SPM:</SharePoint:AjaxDelta>-->
 <!-- remove start and end tags below for DeltaPlaceHolderPageTitleInTitleArea and PlaceHolderPageTitleInTitleArea if already exists in master page -->
 <!--SPM:<SharePoint:AjaxDelta id="DeltaPlaceHolderPageTitleInTitleArea" runat="server">-->
 <!--SPM:<asp:ContentPlaceHolder id="PlaceHolderPageTitleInTitleArea" runat="server">-->
 <!--SPM:</asp:ContentPlaceHolder>-->
 <!--SPM:</SharePoint:AjaxDelta>-->
</div>