Thursday, February 2, 2012

Resolve : The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. (rsSecurityZoneNotSupported)

When we try to open report file in document library, maybe we will find error message like this :

This is a known issue caused by “Report Server Only Supports SharePoint Default Zone”.

Solution: In the Alternate Access Mappings section of the Operations tab in the SharePoint Central Administration Web site, configure the URL you are using for accessing Reporting Services items to be in the Default zone.
 Example :

1. Go to Central Administrator
2. Klik Application Management - Configure alternate access mappings


You see in that the Zone is custom, what must we do is click that url and change it to Default


That's All, you can refresh your report in document library and the error will be missing :)

Tuesday, January 31, 2012

How To Remove Title Column from List or Library

1. Go to your List or your Library
2. Klik List - List Settings - Advanced Settings


3. After you click Advanced Settings, there is column "Content Types", choose "Yes" and klik OK


4. Now you back to your List Settings. In that page, you will see "Content Types", click Item


5. In "List Content Type Information", click column "Title" and Choose "Hidden", Clik OK to finished





6.  We half way to finished. What must we do now, is back to your list , choose" List"  from Ribbon,  click "Modify View" and uncheck column Title and click OK to finished



Now you see, your list or your library. column "Title" disappear. When you try make add new item, column "Title" will disappear too.

I hope i can help you now and have a nice day :)





Web Parts Maintenance Page

This summary is not available. Please click here to view the post.

Tuesday, November 22, 2011

DataSheet View Issue

When we choose DatasheetView, maybe you will find error message like this "...A datasheet component compatible with Microsoft SharePoint Foundation is not installed, your browser does not support ActiveX controls, a component is not properly configured for 32-bit or 64-bit support, or support for ActiveX controls is disabled.."

It happen because we use microsoft office 64 bit. 

For futher information, you can check this link

To solve this problem, it quite simple, we just need download and install "2007 Office System Driver"

You can create datasheet view again and there is no error like above again.

I hope you can enjoy myinformation, any advice is welcome :)

Tuesday, October 18, 2011

How-To Connecting SQL Server Report in Sharepoint


I have experience when i just install SQL Server 2008 R2 stand alone and a few month later i am install Sharepoint 2010.

When I want to make reporting in sharepoint with SQL Server 2008 R2, I just realized i have 2 problem :
  1. There is no Sql Server 2008 R2 Report Builder
  2. In Sharepoint, report server is missing

After i try to search information in google, this is step what i must do :
  1. Download and install Microsoft SQL Server 2008 R2 Report Builder 3.0
  2. Download and install Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies 
  3. Go To Program - Microsoft Sql Server 2008 R2 - Configuration Tools - Reporting Services Configuration Manager
  4. In Left side window - click Database - You will see information Report Server Mode : Native Mode
  5. Klik Change Database - choose "Create a New Report Server Database" - Klik Next - In change database window choose "Sharepoint Integrated Mode" - click Next-Next until finish. You will see like this : 

    6.  Go to Central Administration Sharepoint 2010 - "Site Action" - "Site Settings"
    7.  In "Site Collection Administration" - click "Site Collection Feature"


   8. Two Feature below - click Activate

 
    9. Click General Application Setting - Reporting Service - "Reporting Service Integration"
  10. In Report Server Web Service URL, Fill text box with URL from Web Service URL in
        Reporting  Service Configuration Manager

  11. Klik OK




I hope you can enjoy mytutorial, any advice is welcome :)




How-To Convert an InfoPath Connection to a SharePoint Connection File


When we work in InfoPath Designer 2010 and try to convert info path connection "udl file" into in SharePoint Data Connection "udcx file", there is error somethings like this :


This is happen, because we don't make  "Data Connection Library" in our site.

To make it, it just so simple :

  1. Click "Site Action" => choose "More Option"
  2. Click "Library" => choose "Data Connection Library"
  3. Create your data connection library name.

Repeat your work again in InfoPath Designer 2010 :
  1. In "Data" Ribbon => Click "Data Connection"
  2. Follow step likes picture below, don't forget to choose your site and double click "your data connection library name.
  3. Click "Save" when you done.

Error Message "This feature require sharepoint 2010 or greather with Infopath Form Service enabled"

It happen when you try make "Sharepoint List" in Microsoft Info Path 2010.


This feature just enabled in Microsoft SharePoint 2010 Enterprice and sometimes this service doesn't active.

To check it, you must do like this :
  1. Go to "Central Adminstration Page"
  2. Click "Site Actions" => click "Site Settings" in the bottom
  3. In "Site Collection Administration" => click "Site collection features"
  4. Find "SharePoint Server Enterprise Site Collection features" click "Active" this feature
Now, you can try make new sharepoint list again.

I hope, it will be solving your problem :)