Binding Problem using Pivot

[Charles Benoualid]

Hi,
its possible to do binding in radgridview using index property. I need to do the same in the pivot grid but it does not seem to be working. Any suggestion? It only seem to be working if hardcoding property name in propertyGroupDescription like 'Name' but not working with '[12]' has index property.

[Rosen Vladimirov]

Hi Charles,

This feature is not available with the current release of RadPivotGrid, but we have implemented a custom solution for your case. To do it we have implemented a CustomPropertyGroupDescription which inherits PropertyGroupDescriptionBase and we have overriden GroupNameFromItem method.

Please check the attachment and inform us if you have any problems or suggestions regarding RadPivotGrid.

Regards,
Rosen Vladimirov
the Telerik team

[Charles Benoualid]

This is working if i add CustomePropertyDescription and CustomPropertyAggregate, But how do I had the RadPivotFieldList like you did for customProperty (see picture)? The property that u see right now in the upper part are not related to the index properties. the one selected at the bottom are ok.

And In the project u send me i cannot drag and drop the index property. I dont need static property.

Pier-Luc

[Rosen Vladimirov]

Hi Charles,

To achieve this you have to implement some other custom features - CustomFieldDescriptionProvider, CustomPropertyGroupDescription and CustomFieldInfo. To illustrate how to do it, we've modified our solution and now everything should be working fine with both RadPivotGrid and RadPivotFieldList.

Please check the attachment and feel free to contact us if you still have any problems or concerns.

Kind regards,
Rosen Vladimirov
the Telerik team

[Charles Benoualid]

Hi, I modified your solution to show u my problem (see images). If i use your CustomFieldInfo class everthing is working. But It i try to implement my own TestCustomField (no hardcoding) and set some field, its not working. Drag and drop is not working and Values are duplicated when check mutiple time.
I think its the last step to make it works. Can u send me back the updated solution with no values hard coded for CustomFieldInfo like i did for testCustomFieldInfo.

 

[Rosen Vladimirov]

Hello Charles,

I've modified the solution and now you should be able to drag and drop and use it as you've described. The main problem was in the CustomPropertyGroupDescription's method - GetMemberName - the returned value should be unique.

Please check attached project and inform me if it doesn't suite your needs.

Kind regards,
Rosen Vladimirov
the Telerik team

[Charles Benoualid]

Its working now, thanks.

[Charles Benoualid]

Is it possible to modify the latest solution that was working for beta pivot control to make it works with the full release of PivotGrid... It was working just fine, now in our software it doesnt work anymore and we need a fix as soon as possible. When u drag pivot field to column or row nothing is showing.

See latest solution u sent me.

Thanks.

[Rosen Vladimirov]

Hello Charles,

With our official release we have applied several optimizations and new features. The problem with the mentioned project is that you are adding a GroupDescription for a property which does not exist (the PropertyName is set to [0] for example, but in fact such property doesn't exist). But there is solution for your problem - RadPivotGrid supports ICustomTypeProvider, so you can add properties dynamically. This way you can add the property [0] at runtime and use it. When it is not needed anymore, you can remove it. RadPivotGrid will have no problem to handle such operations. I'm sending you the modified version of the project. Please note that there's no need to use custom FieldDescriptionProvider anymore.

Could you check the attachment and inform us if you have any problems or concerns.

Greetings,
Rosen Vladimirov
the Telerik team

[Rosen Vladimirov]

Hi Charles,

I've just missed to mention, that in the moment we are checking several different ways to make the old solution work. Most probably by the end of the next week we'll have a solution how to achieve this. So if you could wait until then, we'll try to achieve a solution, with which there will be no need to change so much code (as in the last example I've sent you).

Hopefully this makes sense. Feel free to contact us if you have any suggestions or concerns.

Greetings,
Rosen Vladimirov
the Telerik team

[Charles Benoualid]

Any news on a working solution?

[Milan]

Hi,

We still haven't introduced the changes that we have mentioned because we are working on a functionality that is related to the problem that you are having and we need some more time.

Have you tried the other suggestion or you prefer to stick to the original approach?

Kind regards,
Milan
the Telerik team

[Charles Benoualid]

Hi, i prefer to stick to the original approach. Right now i had to remove all pivot grid functionality from our software as the transition from the beta to the release of the pivot control broke my custom solution for this specific problem. If you could provide me a custom solution it would be appreciated.

Thanks.

[Milan]

Hi,

We will do our best to provide a solution with next week's internal build. I will keep you updated.

Greetings,
Milan
the Telerik team

[Milan]

Hi,

I think I have managed to rework the original solution to work with our latest changes. Now it even uses less code. Could you please check if the attached solution works as expected. The difference with the previous approach is that you no longer have to use a custom GroupDescription. The property retrieval logic is now contained in the CustomFieldInfo. Please use our latest internal build from last week.

Kind regards,
Milan
the Telerik team

[Charles Benoualid]

Its working, thanks. I hope this solution will allow export to excel without problem  : )

[Rosen Vladimirov]

Hi Charles,

There shouldn't be any problems with the export. You can check our online demo for the full example and our help article which describes how to export RadPivotGrid.

Feel free to contact us if you have any problems or concerns.

Regards,
Rosen Vladimirov
Telerik