Saturday, March 19, 2011

Change SSRS Report Layout to keep the Column Headers Together

I created a SSRS report with 8 columns. When exporting the report in PDF format, the column headers were separated into two pages with default PORTRAIT layout.

 

image

image

To keep all the column headers together in one page, either I need to change the font size and squeeze them to fit into the 8.5 inches width or change the report layout to be Landscape.  Since it does not look good to squeeze them, I want to change the report to be Landscape layout.

To do it, here are the steps:

  1. Open the Report Properties
  2. Expend the PageSize
  3. Set the Width to 11in and Height to 8.5in and save it.
image

 

Now when exporting the report to PDF file, all the Column Headers are together in one page.

image

Friday, March 11, 2011

Cannot find the Performance Point Server “Decomposition Tree” option on the menu

Recently I am working on a PPS solution for the SharePoint 2010.  PPS 2010 introduces a new feature called Decomposition Tree that allows users to interactively drill down to the details. The Decomposition Tree option enables all of the following in one simple browser window:

  • Show how an individual value in a report can be broken down into its contributing members.
  • See all the members in a group in descending order
  • Choose which dimension you want to use for the next level of detail.

image

After I deploy my new dashboard to the SharePoint site,I cannot find the Decomposition Tree menu by right clicking on the Grid or the Chart.

image 

Doing several researches, I find that there is no Microsoft Silverlight installed on my client machine.

image image

Microsoft Silverlight enables this option. If it is not installed, or disabled, the menu command will be hidden.  In addition, if you are using an analytic chart or grid, you must design it using the Design tab, not the Query tab in order to use the Decomposition tree feature.

image

Tuesday, March 1, 2011

Create SSRS Report with SharePoint 2010 Integrated Mode

With SharePoint 2010, lots people would like to use SSRS Integrated mode. The advantage is that you can deploy data sources, reports, etc. to the SharePoint document library instead of the Report Manager web application. In addition, you could also use the new version of Report Builder that came with SQL Server 2008 R2 and deploy the reports to SharePoint.  Derek Sanderson posted a blog entry: How to Switch from SSRS Native Mode to SharePoint Integrated Mode with detailed graphic information to show step by step how to do it. Once you completed all the installation steps, you may want to create the SSRS reports on it. The following steps show you how to do it.

Create SSRS Report Document Library

In order to deploy or create SSRS artifacts, you need to add a document library with the appropriate content types.

  • Create a new document library called SSRS Report

image

  • Go to the Library tab and click on the Library Settings menu to configure the content type

image

  • In the General settings section, click on the Advanced settings link

image

  • Change the Allow management of content types? to “Yes” and click the OK button to apply the change

image 

  • In the Content Types section, click on the Add from existing site content types link

image

  • Select the Report Builder Model, Report Builder Report, and Report data source content types from the Available Site Content Types list to be added, then click the OK button to apply the change.

image

  • If you want to change the default or the visible order of the content types, you could click on the Change new button order and default content type link and modify accordingly.

image

image

  • Return back to the SSRS Report Document library, and click on the New Document from the Documents tab. Now you should be able to see the Report Builder menus that have been created.

image

  • To launch the Report Builder, click the Report Builder Report menu.  You can now use it to create the SSRS reports and save them to the SharePoint document library.

image

Deploy SSRS Report from Visual Studio to SharePoint
  • To deploy the SSRS report using Visual studio 2008, you will need to point to the SharePoint Server site, not the Report Manager site. Using the example we created, you will need to set the TargetServerURL to be the http://localhost/, and set the TargetReportFolder to be http://Localhost/SSRS Report

image

  • Make sure you don’t append the “/” at end of the TargetReportFolder such as http://Localhost/SSRS Report/, otherwise you will get the following deployment error:

    Error rsItemNotFound : The item 'http://Localhost/SSRS Report//Demo SSRS.rdl' cannot be found.
    Deploy complete -- 1 errors, 1 warnings

image

Manage SSRS Data Sources, Parameters, and Permissions
  • Go to the right side of the report and click the drop down to open the Context Menu. You could set the data source, configure the parameters, or manage the permissions for the report by clicking on the corresponding context menu.

image

View SSRS Report
  • You could now view the report from SharePoint Site by clicking on the report itself.

image

  • Or view the report from the Report Server Site by navigating to the report directory.

image