SharePoint Web Part

XLCubed Version 6.2 introduces the XLCubed SharePoint Webpart, this allows XLCubed Reports to be embedded into SharePoint pages and allows connections between filter web-parts and other XLCubed Report web-parts. This is currently in Beta, please contact support@xlcubed.com if you'd like to gain access to this feature.

Installing

The required CAB file is installed as part of Web Edition and can be found in the Extensions directory of the website, for example c:\inetpub\wwwroot\xlcubedweb\extensions.

Sharepoint 2010

The instructions assume XLCubed Web is installed on the same machine as SharePoint and is either accessible under the main site http://sharepointsrv/xlcubedweb or via a different port http://sharepointsrv:8080/xlcubedweb.

• Enable full trust in IIS - run Internet Information Services Manager.
  • Click on the server and select .Net Trust Levels

• Change the trust level to Full (Internal)

• Run the Sharepoint 2010 ManagementShell (Start -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell:

• Register the .CAB with Sharepoint:
  • Add-SPSolution -LiteralPath c:\inetpub\wwwroot\xlcubedweb\extensions\XLCubed.Sharepoint.cab

• Deploy the webpart to the Sharepoint websites
  • Install-SPSolution -Identity xlcubed.sharepoint.cab -allwebapplications -force

The webpart show now be available in the list of available webparts, under the "Miscellanous" items

Uninstalling

Sharepoint 2010

• Run the Sharepoint 2010 ManagementShell (Start -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell:

• Remove the webpart from the Sharepoint websites
  • UnInstall-SPSolution -Identity xlcubed.sharepoint.cab -allwebapplications

• Remove the .CAB from Sharepoint:
  • Remove-SPSolution xlcubed.sharepoint.cab

Using WebPart

Configuring

Insert the XLCubed Webpart:

Edit the Webpart:

Setup the XLCubed web server details and click OK:

Now the Report browser button will be enabled:

Click on the button and browse to the report to display on this page:

Give the report a defined height (if not already inserted into a control with a height defined)

Click OK/Apply to see the report embedded in the page

Linking XLCubedReport WebParts

XLCubed Webparts can be linked via Web Parameters - once a link is in place then when the web parameters with the same name are passed between the linked WebParts.

Insert 2 or more webparts in the same page, the select the Connections menu when editing the webpart:

Linking to filter WebParts

XLCubed Webparts can be linked to Filter webparts so that the parameters can be passed into the XLCubed Report - first you would need to defined the Web Parameters to be driven by the Filter control.

Then select the connections menu and Inbound Parameters - select the filter control to receive the parameter from

Select which Web Parameters is to receive the data from the filter: