RadPivotGrid Calculated Item

[Tim]

Hi All,

Is there any possible way to set dataformatstring of a Calculated Item? I am customising the calculation behind the C# code and would like to format it into {0:p0}.

Right now, e.CalculatedValue is a double without any format.

Many thanks.

[Tim]

Is there anyway I can update the dataformatstring of a specific cell, row/column dependent on the e.GroupName.ToString()?

[Angel Petrov]

Hello Tim,

In order to change a row, column or a cell value you can subscribe to the OnCellDataBound event, extract the old value, format it in the described manner and set the formatted value as current. If you need to format the values according to the column or row header texts you can use the ParentColumnIndexes and ParentRowIndexes and check to which row/column does the cell belong. For example:

C#:

protected void RadPivotGrid1_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)
    {
        PivotGridDataCell cell = e.Cell as PivotGridDataCell;
        if (cell != null)
        {

            if (cell.ParentColumnIndexes.Contains("ParentColumnValue"))
            {
                string currentValue=cell.Text;
                cell.Text = currentValue + " is modified";
            }

            if(cell.ParentRowIndexes.Contains("ParentRowValue"))
            {
                string currentValue = cell.Text;
                cell.Text = currentValue + " is modified";
            }
        }
    }

The above code will modify the text of the cells which belong to a column with ParentColumnValue set as header text or row with ParentRowValue used as header text.

Regards,
Angel Petrov
Telerik

 

 

[Tim]

Thanks Angel,

That's a perfect solution to my problem.

Cheers!

[Tim]

Last question, while the cell.ParentColumnIndexes and its row counterparts are working perfect for normal radpivotgird cell, for calculated fields, the ParentColumnIndexes/ParentRowIndexes are object {Telerik.Web.UI.RadPivotGrid.GeneralCalcualtedItem} but not normal string. And therefore the Contains is not reading my header text.

Any suggestion of what if clause I should use? Thanks.

[Tim]

While the cell.ParentColumnIndexes/ParentRowIndexes are working perfect for normal radpivotgird cell, for calculated fields, the ParentColumnIndexes/ParentRowIndexes are object {Telerik.Web.UI.RadPivotGrid.GeneralCalcualtedItem} but not normal string object. And therefore the Contains method is not reading my header text.

Any suggestion of what if clause condition should I use? Thanks.

[Tim]

Any reference document that I can take a look on? Much appreciated.

[Angel Petrov]

Hi Tim,

Actually you should be able to integrate the same approach for the calculated fields. By traversing the ParentColumnIndexes and ParentRowIndexes collections and calling .ToString() you should be able to extract the header values. An example on to achieve this is available in the code snippet below.

C#:

protected void RadPivotGrid1_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)
        {
            PivotGridDataCell cell = e.Cell as PivotGridDataCell;
            if (cell != null && cell.CellType == PivotGridDataCellType.DataCell)
            {
                foreach (object parentColumn in cell.ParentColumnIndexes)
                {
                    string columnValue=parentColumn.ToString();
                    if(columnValue=="Forecast for 1999")
                    {
                        cell.Text = "Changed";
                    }
                }
            }
        }

Please note that we will do our best to include such an example in the documentation as soon as possible.

Regards,
Angel Petrov
Telerik

 

 

[Tim]

Thank you very much!