[Solved] Group Footer and Aggregates export showing unwanted info

[Spartan IV]

 

  [QCVG: Key=Australia; ItemCount=48; HasSubgroups=False; ParentGroup=[QCVG: Key=Root; ItemCount=897; HasSubgroups=True; ParentGroup=null];]; [QCVG: Key=Australia; ItemCount=48; HasSubgroups=False; ParentGroup=[QCVG: Key=Root; ItemCount=897; HasSubgroups=True; ParentGroup=null];]; [QCVG: Key=Australia; ItemCount=48; HasSubgroups=False; ParentGroup=[QCVG: Key=Root; ItemCount=897; HasSubgroups=True; ParentGroup=null];]; [QCVG: Key=Australia; ItemCount=48; HasSubgroups=False; ParentGroup=[QCVG: Key=Root; ItemCount=897; HasSubgroups=True; ParentGroup=null];]; 417 0 [QCVG: Key=Australia; ItemCount=48; HasSubgroups=False; ParentGroup=[QCVG: Key=Root; ItemCount=897; HasSubgroups=True; ParentGroup=null];]; 185 [QCVG: Key=Australia; ItemCount=48; HasSubgroups=False; ParentGroup=[QCVG: Key=Root; ItemCount=897; HasSubgroups=True; ParentGroup=null];]; 309,848

Why this information is displayed where I don't have an aggregate?

If there is not an aggreate on the group footer it should be empty, this is not what I wanted. I need to export aggregate results

[Spartan IV]

Well found an easy solution:

This is from the demo code:

...
else if (e.Element == ExportElement.GroupFooterCell)
{
    GridViewDataColumn column = e.Context as GridViewDataColumn;
    QueryableCollectionViewGroup qcvGroup = e.Value as QueryableCollectionViewGroup;
    if (column != null && qcvGroup != null && column.AggregateFunctions.Count() > 0)
    {
        e.Value = GetAggregates(qcvGroup, column);
    }
    else
    {
        e.Value = String.Empty; //If you don't do that you will get all that unwanted info
    }
}

//Common sense :)