SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the requirement to add performance point filter web part and report view web part to a page in SharePoint 2010 programmatically. I can add both web parts to the page however I have no idea on how to setup connection between them, i.e. for filter web part to be able to send its value to the report view web part.

Any help would be much appreciated.

share|improve this question

Found the solution to this :)

What I did was when I create the connection using SPConnectWebParts, I use TransformableBIDataProviderTransformer object, e.g.

   var list = new List<TransformProviderConsumerRecord>();
   var transformer = new TransformableBIDataProviderTransformer();

   var tpcRecord = new TransformProviderConsumerRecord();
   tpcRecord = "SqlReportViewUniqueParameterIdSI1";
   tpcRecord.ProviderParameterName = "FilterValues";
   tpcRecord.DisplayColumnName = "DisplayValue";
   tpcRecord.MappingId = (new Guid()).ToString();
   tpcRecord.ProviderParameterDisplayName = "PerformancePoint Values";
   tpcRecord.TypeFullName = "System.String";
   tpcRecord.ValuesColumnName = "DisplayValue";

   ProviderConsumerTransformations provConsTransf = new    ProviderConsumerTransformations(list);

   var tcr = new TransformerConfigurationRecord(provConsTransf, new       TransformConditionalVisibilityRecord());
   transformer.ConfigurationState = tcr;

   wpm.SPConnectWebParts(providerWp, providerConnection, consumerWp, consumerConnection, transformer);

Where providerWP is Performance Point filter web part amd consumerWp is Performance Point Report

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.