Hi Valerie,

We have updated to 11.2 and the tenor row sorting no longer works.

Here is my code, NOTE that i am using DynamicTypeBuilder to create my object and this way of adding and sorting the tenor hierarche worked in 11.1, however something must have changed in 11.2 and now no sort is applied. Could it be to do with the way i create a HierarcheDiscriptor for a DynamicType object:

  Expression<Func<object, DateTime>> tenorExpression =
                dynamicMarketDataResult =>
                TennorHelper.EvaluateTenorSort(
                    dynamicMarketDataResult.GetType().GetProperty("TENOR").GetValue(
                        dynamicMarketDataResult, null).ToString());

            var hierarchy = new HierarchyDescriptor { SourcePropertyName = "TENOR" };
            var level = new HierarchyLevelDescriptor
                                  {
                                      LevelName = "TENOR",
                                      LevelExpressionPath = "TENOR"
                                  };
            hierarchy.LevelDescriptors.Add(level);
            hierarchy.LevelDescriptors[0].OrderByKeyExpression = tenorExpression;

....

Here is my sort expression which works correctly.

public static DateTime EvaluateTenorSort(string tenor)
        {
            var date = DateTime.MinValue;
            if (tenor == null) return date;
            int tenorNum;
            if (tenor.ToUpper().Contains("D"))
            {
                int.TryParse(tenor.Substring(0, tenor.ToUpper().IndexOf('D')), out tenorNum);
                return date.AddDays(tenorNum);
            }
            if (tenor.ToUpper().Contains("W"))
            {
                int.TryParse(tenor.Substring(0, tenor.ToUpper().IndexOf('W')), out tenorNum);
                return date.AddDays(tenorNum*7);
            }
            if (tenor.ToUpper().Contains("M"))
            {
                int.TryParse(tenor.Substring(0, tenor.ToUpper().IndexOf('M')), out tenorNum);
                return date.AddMonths(tenorNum);
            }
            if (tenor.ToUpper().Contains("Y"))
            {
                int.TryParse(tenor.Substring(0, tenor.ToUpper().IndexOf('Y')), out tenorNum);
                return date.AddYears(tenorNum);
            }
            return date;
        }

Has something changed in 11.2 with regard to sorting as this all worked in 11.1 and the row sorting is key functionality for us.

Thanks,

Nick

Hello Nick,

The following link shows how to expand the hierarchies:

http://help.infragistics.com/Help/NetAdvantage/WPFDV/2011.1/CLR4.0/html/xamPivotGrid_US_Expanding_Hierarchies_In_Runtime_From_Code.html

Sincerely,

Valerie

Developer Support Engineer

Infragistics

www.infragistics.com/support

Hi Valerie,

Thanks for the reply, adding a hierarchy and sort expression did the job.

I will get back to you regarding request 2, we are currently evaluating if it is a necessity for the users.

Regarding point 3, we are using the pivot grid to display market data therefore total rows/columns and aggregations do not make sense. I have found a way to remove the total rows and columns but was wondering if there was a simple way to always have the pivot grid in fully expanded mode.

Secondly our scenario is as follows:

• the user has chosen to pivot on "product  type:" swap and "tenor:" 10 year
• the underlying data contains 2 market data entries on such a pivot, they differ in year convention 360 and 365.
• as i mentioned above we don't want to show an aggregated value for the 360 and 365 convention, therefore we want to display to the user that the data is aggregated. This will indicate to the user that they need to add an additional level for "year convention" in order to get the fully expanded data. Is that possible?

Regards,

Nick