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 :)


Comparing SharePoint List and Form Library Forms

This information taken from : http://blogs.msdn.com/b/infopath/archive/2010/04/22/comparing-list-and-form-library-forms.aspx


When designing InfoPath forms for SharePoint 2010, the first choice you need to make is between a SharePoint list form and a SharePoint form library form.
Popular Form Templates
Recommendation
Use a list form if you just need to collect data and store it on SharePoint. Use a form library form if you want more advanced functionality such as complex or repeating data or code.

What are list forms and form library forms?

SharePoint list forms store data directly in a SharePoint list.  Each control (e.g. text box) in the form is bound to a column in the list. SharePoint list forms are directly connected to the list, which means that you don’t have to worry about setting up the publish and submit locations.
Form library forms store data in XML files in a SharePoint form library. This means they are more flexible and you can do more with them. For example, they can be configured to save drafts and submit to different locations. However, they are more complex to work with and require more decisions to be made during configuration.
Because the way data is stored between these template types is different, it is not possible to switch between them.

Guidelines

Here are some basic guidelines to help you decide what type of form to design.

Use a list if:

  • You want to quickly get started building InfoPath forms on SharePoint
  • You need to use your form offline with SharePoint Workspace (formerly Groove)
  • You want to filter your SharePoint list based on a person or group
  • You would like to use the built-in display / edit views

Use a form library if:

  • You have repeating or nested data
  • You are working from a predefined industry or complex schema
  • Your form needs to be digitally signed
  • You need code in your form
  • Your form is not hosted in SharePoint or you need to store results as an XML document 

 

How can I build advanced functionality into my forms?

In general, form libraries provide better support for more complex and advanced forms. Here are a few examples of the way InfoPath can be used to build more powerful forms.

Repeating data or complex schema

  • In some cases, you will want to collect repeating data in a form. For example, you have a project proposal form and want to include a list of potential risks for each project, or you have a book request form where users can request multiple books at once.
  • If you have a schema that has any nesting or repeating structures, or a defined industry schema such as Dublin core or Health Level 7, form library forms will allow you to organize your fields into groups to match your schema as opposed to having to flatten your schema to work with a list.
  • SharePoint lists store only one value per column; you can’t use list forms to store repeating data in a single item. As form library forms use XML to store data they can store repeating data in a single form.

Using repeating data in list forms

  • If you have a SharePoint list form, you have several options for dealing with repeating data other than using the built in support of a form library.
  • If part of your content is repeating, consider flattening that schema so that it can repeat. For example, you could limit your book request form to no more than ten books per form.
  • You can also use multiple lists and link them together using lookup fields and web part connections. This works well for master/detail scenarios where one list tracks all the items and another contains the specific details for each item.

Using repeating data in form library forms

  • Form library forms include controls that are designed to deal with repeating data inside the current item.  Form libraries have built-in support for repeating data with controls such as plain list, bulleted list, numbered list, repeating table, and repeating section.
  • They also support more customization of the form using the choice group and choice section controls. Advanced choice controls such as option button and optional sections are also available. All of these controls will be available by default in the controls gallery in InfoPath Designer for form library forms.

Digital Signatures

Managed Code

  • Form libraries support code-behind. This will allow you to do actions beyond logic in your form, such as advanced financial calculations.
  • Code can be used to extend InfoPath functionality or create custom business logic.
  • For example, in a pet food store you may use an InfoPath form to track food orders and use code behind the scenes to make sure you have enough inventory to meet the order and make sure that it isn’t sold before the form is submitted.
  • For more detail about forms with code, see Introduction to Programming in InfoPath 2010.

Control over where your form is stored

  • Form libraries allow you to choose the location of where your form XML is sent when the form is submitted.
  • If you need to store your form as an XML document for use outside of SharePoint, then you should use a form library.
  • For example, if you have an insurance questionnaire and you want to store the completed form in a document collection with related content, a form library will allow you to do this.

Bottom line

Overall, both list forms and form library forms support much of the key functionality that InfoPath provides, such as data validation, custom rules, default values, and control over visual layout. In most cases, a list form will be sufficient for your needs. Lists have the most straightforward design and form management experience. However, for more complex scenarios such as repeating data or the need to add code, a form library may be necessary.
Please leave a comment if you have any further questions!
Daniel Broekman and Kate Everitt
InfoPath Program Managers