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

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,

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 Doug,

If you have added sorting criteria to your HierarchyDescriptor and you have enabled row/ column sorting then when you click the sort indictor the columns /rows should be sorted based on the sort expression you have defined for the hierarchy. I tested this in 11.1 build 2053 and the columns / rows where sorted correctly after pressing the sort indicator.

Please let me know if you have any questions.

Sincerely,

Valerie

Developer Support Engineer

Infragistics

www.infragistics.com/support

Hi Valerie,

We are using version 11.1.20111.2053 and I would like to know whether the sorting works in this version or not. From what I see it doesnt but I need to make sure it isnt just my code is wrong.

We cannot easily upgrade to the next service release or indeed 11.2 as we get some problems after the upgrade that I havent had time to fix, so for the moment we need to stick to that release.

Thanks,
Doug Rees

Ralph Lauren.

Hi Valerie,

Thanks for the update. Looking forward to trying it out once it gets released.

Regards,
Nick

Hi Valerie,

Our datasource sort is getting more and more complicated as we want to sort more than one field at a time. The custom sort functionality in 11.1 used to work perfect for us and i am surprised that it was taken out. Is this a bug that will be resolved in future updates as we found the custom sort per field very useful.

Regards,
Nick