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

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

In the screenshot i attached on the first post you can see products Swap and Basis Swap, we would like to allow the user to define a format mask for Swap (e.g. 4 decimal places), but a different format mask (e.g. percentage) for Basis Swaps. What is the easiest approach to apply conditional formatting based on one of the properties of the databound object (in our case Product Type)?

Thanks,

Nick

Hi Valerie,

Thanks for your reply, regarding the sorting problem i am attaching a simple VS app that demonstrates how custom sort works correclty in 11.1 and does not in 11.2. When you run the app the Infragistics references are for 11.2 and the tenors appear in the order they are added to the collection. If you then change all the Infragistics references to 11.1 you will notice that the custom sort now works and the items are sorted correctly. Why is this not working in the same way for 11.2?

Regards,
Nick

Hello Nick,

What is the version of 11.1 you have? The 11.1 RTM uses the custom sort by default and the order of items in the collection doesn’t matter. Since 11.1 SR1 we restored the earlier behavior where by default members appear in the order they are added to the collection.

Regards,

Plamen.

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