or
<telerik:GridTemplateColumn HeaderText="One" SortExpression="One" DataField="One" UniqueName="One" ItemStyle-Width="10%" HeaderStyle-Width="10%"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "One").ToString%> </ItemTemplate></telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Two" SortExpression="Two" UniqueName="Two" DataField="Two" ItemStyle-Width="15%" HeaderStyle-Width="15%"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "Two").ToString().Split(" ")(0)%> </ItemTemplate></telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Three" SortExpression="Three" DataField="Three" UniqueName="Three" ItemStyle-Width="20%" HeaderStyle-Width="20%"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "Three").ToString%> </ItemTemplate></telerik:GridTemplateColumn><telerik:GridTemplateColumn HeaderText="Four" SortExpression="Four" DataField="Four" UniqueName="Four" ItemStyle-Width="20%" HeaderStyle-Width="20%"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "Four").ToString.Replace(Chr(13),"</br>")%> </ItemTemplate></telerik:GridTemplateColumn><telerik:GridTemplateColumn HeaderText="Five" SortExpression="Five" UniqueName="Five" DataField="Five" ItemStyle-Width="20%" HeaderStyle-Width="20%"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "Five").ToString%> </ItemTemplate></telerik:GridTemplateColumn><telerik:GridTemplateColumn HeaderText="Six" SortExpression="Six" UniqueName="Six" DataField="Six" ItemStyle-Width="8%" HeaderStyle-Width="8%"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "Six").ToString().Split(" ")(0)%> </ItemTemplate></telerik:GridTemplateColumn>I am having trouble getting the Q3 2013 PivotGrid (most recent release) to display data from the Pivot Grid control.
My pivot grid definition (I have no code-behind related to it) is below, along with some code I have in the PageLoad function of the page. The code from the PageLoad function works fine, but I can't seem to get anything to display in the PivotGrid. According to the SQL 2012 docs, we don't need to use msmdpump.dll anymore for remote access. Is that part of my problem?
I have the Microsoft.AnalysisServices.AdomdClient (v11) referenced and in the bin folder of the web site.
Pivot Grid code:
<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server"> <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox"/> <OlapSettings ProviderType="Adomd"> <AdomdConnectionSettings Cube="UtilitySmart" Database="UtilitySmart" ConnectionString="Data Source=SERVERNAME; Catalog=UtilitySmart;"> </AdomdConnectionSettings> </OlapSettings> <Fields> <telerik:PivotGridRowField DataField="[Dim Utility Smart Property].[Portfolio]" Caption="Portfolio" UniqueName="Portfolio"/> <telerik:PivotGridAggregateField DataField="[Measures].[AmtPaid]" Caption="Amount Paid" UniqueName="AmtPaid"/> </Fields> <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True" LayoutType="OneByFour"/> </telerik:RadPivotGrid>var conn = new AdomdConnection("Data Source=SERVERNAME;Catalog=UtilitySmart;"); conn.Open(); var cmd = new AdomdCommand("SELECT [Dim Utility Smart Property].[Portfolio].Members ON ROWS, [Measures].[Amt Paid] ON COLUMNS FROM [UtilitySmart] ", conn); var resultObj = cmd.Execute();protected void ValidateButton_Click(object sender, EventArgs e) { // Foreach loop that will need to access the header controls and determine what a user selected in a dynamically injected //combobox...//}protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridHeaderItem) { GridHeaderItem item = e.Item as GridHeaderItem; var columnName = "Column"; var columnCount = 0; foreach (GridColumn col in RadGrid1.MasterTableView.AutoGeneratedColumns) { RadComboBox radCombo = new RadComboBox(); radCombo.ClientIDMode = ClientIDMode.Static; radCombo.ID = "Column" + columnCount; radCombo.EmptyMessage = "Select Field"; //Need to get fields and etc,then loop and add var receiveByTagsFields = GetReceiveByTagFields(Convert.ToInt32(PurchaseShipmentUid)); foreach (var field in receiveByTagsFields.ReceiveByTagImportFields.OrderBy(x => x.Label)) { RadComboBoxItem CBitem = new RadComboBoxItem(); CBitem.ClientIDMode = ClientIDMode.AutoID; CBitem.Text = field.Label; CBitem.Value = field.Id.ToString(); radCombo.Items.Add(CBitem); } if (receiveByTagsFields.MetaFields.Count() != 0) { foreach (var field in receiveByTagsFields.MetaFields.OrderBy(x => x.Label)) { RadComboBoxItem CBitem = new RadComboBoxItem(); CBitem.ClientIDMode = ClientIDMode.AutoID; CBitem.Text = field.Label; CBitem.Value = field.InventoryMetaUid.ToString(); radCombo.Items.Add(CBitem); } } LinkButton link = new LinkButton(); link.ClientIDMode = ClientIDMode.AutoID; link.Text = "Edit"; LiteralControl br = new LiteralControl("<br />"); if (col.ColumnType == "GridBoundColumn" || col.ColumnType == "GridNumericColumn") { item[col.UniqueName].Controls.Add(br); item[col.UniqueName].Controls.Add(radCombo); } radCombo.Items.Add(new RadComboBoxItem("Do not import", "-1")); columnCount++; } } }
