将Office 图表组件(OWC)绑定到数据透视表的方法

        <p align="Center">
            <button id="btnOneChart" style="width:200" οnclick="btnOneChart_OnClick();">显示量值群组到一个图</button>&#xa0;&#xa0;
            <button id="btnMultiChart" style="width:200" οnclick="btnMultiChart_OnClick();">每个量值分开图显示</button>&#xa0;&#xa0;
      
            <br/><br/>
<%--            <object classid="clsid:0002E556-0000-0000-C000-000000000046" id="CSpace" width="95%" height="55%">
            </object>
            <br/><br/>
            <object classid="clsid:0002E552-0000-0000-C000-000000000046" id="PTable" width="95%" height="35%">
                <param name="AutoFit" value="false"/>
            </object>--%>
            <object classid="clsid:0002e55d-0000-0000-c000-000000000046" id="CSpace" width="95%" height="55%">
            </object>
            <br/><br/>
            <object classid="clsid:0002e55a-0000-0000-c000-000000000046" id="PTable" width="95%" height="35%">
                <param name="AutoFit" value="false"/>
            </object>
        </p>
        <input type="hidden" id="OlapConnStr" value="<%=System.Configuration.ConfigurationSettings.AppSettings["olapConnStr"].ToString() %>" />
        <script language="javascript" type="text/javascript">
            var c;
            var sServerName;
            c = CSpace.Constants;
            sServerName = "localhost";
            btnBreakOut.disabled = true;
//          BuildPivot(); 
           
//            alert(document.getElementById("OlapConnStr").value);//test
            BuildPivot(document.getElementById("OlapConnStr").value);            
           
            function BuildPivot(olapConnStr)
            {

                var c;
                var sServerName;
                c = CSpace.Constants;
                sServerName = "localhost";
               
                PTable.ConnectionString =olapConnStr;
                PTable.DataMember = "EnergyCube";
                CSpace.DataSource = PTable;          
                CSpace.Charts(0).Type = c.chChartTypeBarClustered;

                CSpace.HasMultipleCharts = false; 
                CSpace.PlotAllAggregates = c.chPlotAggregatesSeries;
                CSpace.HasChartSpaceLegend = true; 
                btnBreakOut.disabled = false;          
            }
           
            function BuildPivot()
            {          
    
               PTable.ConnectionString = "Provider=MSOLAP.3;Persist Security Info=true;Initial Catalog=SSASDB;Data Source=localhost;Catalog=SSASDB;Client Cache Size=25;Auto Synch Period=10000";
    
               PTable.DataMember = "EnergyCube";
               CSpace.DataSource = PTable;
    
              
                CSpace.Charts(0).Type = c.chChartTypeBarClustered;
              
                CSpace.HasMultipleCharts = false;
                CSpace.PlotAllAggregates = c.chPlotAggregatesSeries;
                CSpace.HasChartSpaceLegend = true;
                btnBreakOut.disabled = false;
            }

            function btnOneChart_OnClick()
            {             
                CSpace.HasMultipleCharts = false;
                CSpace.PlotAllAggregates = c.chPlotAggregatesSeries;
                CSpace.HasChartSpaceLegend = true  ;
                btnBreakOut.disabled = false;
            }

            function btnMultiChart_OnClick()
            {
                CSpace.HasMultipleCharts = true;
                CSpace.PlotAllAggregates = c.chPlotAggregatesCharts;
                CSpace.HasChartSpaceLegend = false;
                CSpace.ChartWrapCount = 3;
                CSpace.HasChartSpaceLegend = true ;   
                NormalizeAxes();
                btnBreakOut.disabled = false;
            }

 

            function NormalizeAxes()
            {
               if(CSpace.Charts.Count>0 )
               {
                  var ValueMax;

                  for(oCht in CSpace.Charts)
                  {
                     max = oCht.Axes(c.chAxisPositionValue).Scaling.Maximum;
                     if (ValueMax < max)
                     {
                        ValueMax = max;
                     }             
                  }
                  for(oCht in CSpace.Charts)
                  {
                     oCht.Axes(c.chAxisPositionValue).Scaling.Maximum = ValueMax;
                  }
               }
            }       
        </script>