Hi Team,
I am binding grid to the out put of a stored procedure on page load.

I see some dummy blank rows getting added. Can you please let know on how i can remove this.
[ I have checked my stored procedure and it is not returning any blank row]

***********************************
I am adding the summary row like this. The below code is in page load.

private void radgrid_ViewCellFormatting_1(object sender, CellFormattingEventArgs e)
        {
           
                GridSummaryCellElement cell = e.CellElement as GridSummaryCellElement;
                if (e.CellElement != null)
                {
                    if (e.CellElement.Text.Contains("$-"))
                    {
                        e.CellElement.Text = e.CellElement.Text.Replace("$", "").Replace("-", "($") + ")";
                        e.CellElement.TextAlignment = ContentAlignment.MiddleRight;
                    }
                }
          }

private void radgrid_CellFormatting(object sender, CellFormattingEventArgs e)
        {
                GridSummaryCellElement cell = e.CellElement as GridSummaryCellElement;
                if (e.CellElement != null)
                {
                    if (e.CellElement.Text.Contains("$-"))
                    {
                        e.CellElement.Text = e.CellElement.Text.Replace("$", "").Replace("-", "($") + ")";
                        e.CellElement.TextAlignment = ContentAlignment.MiddleRight;
                    }
                }
        
}