Hi,
I am new to .Net programming and trying to impliment RadPivotGrid to develop a report.
There is no issue with RadPivotGrid implimentation. But, having difficulties in accessing Row and Column Group values.
As shown in Code behind, I am looking for corresponding sic_2_code and effective_year value for selected data cell.
<Fields>
<telerik:PivotGridRowField DataField="sic_2_code" Caption="SIC Group" ZoneIndex="0">
</telerik:PivotGridRowField>
<telerik:PivotGridColumnField DataField="effective_year" Caption="Year" ShowGroupsWhenNoData="false">
</telerik:PivotGridColumnField>
<telerik:PivotGridAggregateField DataField="Proposed Premium" DataFormatString="{0:$#,##0}">
<CellTemplate>
<asp:LinkButton ID="LB_ProposedPremium" runat="server" OnClick="LB_ProposedPremium_Click">
<%# string.Format("{0:$#,##0}", Container.DataItem)%>
</asp:LinkButton>
</CellTemplate>
</telerik:PivotGridAggregateField>
</Fields>
Code Behind
protected void LB_ProposedPremium_Click(Object sender, EventArgs e)
{
string sBusinessSegment = string.Join(",", RCB_BusinessSegment.CheckedItems.Select(x => x.Value).ToArray());
//I need values of sic_2_code and effective_year to pass to another page
string sSICCode =??
string sEffectiveYear =??
StringBuilder sb = new StringBuilder();
sb.Append("NB_YearToYearSales.aspx");
sb.Append("?SegmentID=" + sBusinessSegment);
sb.Append("&SICCode=" + sSICCode);
sb.Append("&EffectiveYear =" + sEffectiveYear);
Response.Redirect(sb.ToString());
}
I am new to .Net programming and trying to impliment RadPivotGrid to develop a report.
There is no issue with RadPivotGrid implimentation. But, having difficulties in accessing Row and Column Group values.
As shown in Code behind, I am looking for corresponding sic_2_code and effective_year value for selected data cell.
<Fields>
<telerik:PivotGridRowField DataField="sic_2_code" Caption="SIC Group" ZoneIndex="0">
</telerik:PivotGridRowField>
<telerik:PivotGridColumnField DataField="effective_year" Caption="Year" ShowGroupsWhenNoData="false">
</telerik:PivotGridColumnField>
<telerik:PivotGridAggregateField DataField="Proposed Premium" DataFormatString="{0:$#,##0}">
<CellTemplate>
<asp:LinkButton ID="LB_ProposedPremium" runat="server" OnClick="LB_ProposedPremium_Click">
<%# string.Format("{0:$#,##0}", Container.DataItem)%>
</asp:LinkButton>
</CellTemplate>
</telerik:PivotGridAggregateField>
</Fields>
Code Behind
protected void LB_ProposedPremium_Click(Object sender, EventArgs e)
{
string sBusinessSegment = string.Join(",", RCB_BusinessSegment.CheckedItems.Select(x => x.Value).ToArray());
//I need values of sic_2_code and effective_year to pass to another page
string sSICCode =??
string sEffectiveYear =??
StringBuilder sb = new StringBuilder();
sb.Append("NB_YearToYearSales.aspx");
sb.Append("?SegmentID=" + sBusinessSegment);
sb.Append("&SICCode=" + sSICCode);
sb.Append("&EffectiveYear =" + sEffectiveYear);
Response.Redirect(sb.ToString());
}