Sharepoint – Bruce Ng's software development blog

Default Values for parameters not working in SSRS with SharePoint integration

I faced this problem while trying to set default values to parameters in a report that resides within the SharePoint site.

It turned out that once a report is uploaded to SharePoint, the default values for parameters are maintained in the server, so subsequent changes to the default values will have no effect after saving or overwriting the report in the server.

To solve this, delete the report from the server and upload the report again. Quite stupid, but it works.

Find /bin folder for SSRS integrated with SharePoint

SharePoint strikes again.

Follow the article http://blogs.catapultsystems.com/aroney/archive/2013/02/11/custom-dlls-with-sql-server-reporting-services-in-sharepoint-integrated-mode/

Normally, you can find the SSRS at C:\Program Files\Microsoft SQL Server\ MSRS10_50.SQLSERVER\Reporting Services\

If you want to find the folder for SSRS integrated with SharePoint, it’s not where it’s usually located but under the /15 hive, C:\Program Files\Common Files\Microsoft Shared\Web Service Extensions\15\Webservices\reporting\bin

Uninstall and remove all SharePoint solutions

Follow the article here : http://joelblogs.co.uk/2011/11/06/uninstall-all-sharepoint-2010-solutions-via-powershell/

Consume a WCF webservice in SharePoint solution

Follow the article http://www.sharepointdevelopment.me/2011/01/how-to-consume-wcf-in-a-web-part-without-touching-the-web-config-file/

Changing masterpage for a application page in SharePoint 2013

Follow the answer: http://sharepoint.stackexchange.com/questions/156521/error-the-referenced-file-catalogs-mycustompage-master-is-not-allowed-on-th

It seems the masterpage needs to be included in the project.

The masterpages under /_catalogs/masterpage are publishing masterpages, they are stored in the Content DB. It seems for application pages the server only searches for masterpages under the _layouts folder.

Trouble shooting sharepoint restore errors

It might be because the schema of the backup doesn’t match the target site

Follow the answers

http://sharepoint.stackexchange.com/questions/76804/what-is-causing-this-error-restore-spsite-nativehr0x80070003-nativehrn

Backup and Restore SharePoint farm by doing a database detach and reattach

Follow the article
https://technet.microsoft.com/en-us/library/ff628582.aspx

Backup and Restore web apps in Sharepoint 2013

Follow the articles

https://technet.microsoft.com/en-us/library/ee748650.aspx

https://technet.microsoft.com/en-us/library/ee748647.aspx#proc1

Enable ASP.NET Session state in SharePoint

The only way to enable session state in SharePoint is through PowerShell

Follow the article: http://nikpatel.net/2012/02/12/enable-asp-net-session-state-on-sharepoint-2010-application/

Delegate Control not showing on Master Page in SharePoint 2013

This issue occurred because the value for ControlSrc in Elements.xml is not correct. The path to the user control must point to the file in the folder structures for SharePoint 2013(15 Hive)

Refer to the .cs file for the webpart which has the path to the user control file generated by Visual Studio. Generally the path must start with “~/_ControlTemplates/15/…”