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