PivotGrid data loading status

[Shiv Ram Ameria]

Hello,

 

I am using Pivot Grid which has its DataProvider’s ItemSource as DataTable with large number of rows (around 500000).

Pivot grid takes some time to display this data and shows wait window which says “Loading…”.

 

1. Is there any way to find out status of DataProvider or PivotGrid control which indicates that data is being displayed in pivot grid control? I checked DataProvider Status and this is always “Ready” during this time. Actually pivot grid starts showing data only when DataProvider becomes Ready, but then if there is huge data to display, I want to do some operations during this time and also when data is fully shown to pivot grid.

 

1. Also I want to know if I can override default wait window and show my own wait window.

 

Kindly let me know if I can achieve this somehow.

 

Thanks,

Shiv Ram

[Rosen Vladimirov]

Hi Shiv Ram,

LocalDataSourceProvider has StatusChanged event which is raised each time the Status is changed. RadPivotGrid will show data only when the Status is Ready. So you can use it to know when the state is ready. Status property of LocalDataSourceProvider is the other option you have to get the current state of the data provider.

In order to modify the "wait" window, you have to modify RadPivotGrid's style. We are using RadBusyIndicator, but you can use whatever control you want. I'm sending you a sample project demonstrating how to replace the BusyIndicator with a Rectangle. Please check it and inform us in case you have any problems or concerns.

Regards,
Rosen Vladimirov
Telerik

[Shiv Ram Ameria]

Hi Rosen,

Thanks for your reply. This solves my second problem of showing different wait window, but my first point was actually to know more about this "IsBusy" property on PivotGrid. I wanted to know when PivotGrid is set as busy and when its again ready.
I want to perform some operations when its ready, say want to change status bar to show that pivot grid is generated.
Is there any IsBusyChanged event or something like this which tells me when pivot grid is ready?

Thanks,
Shiv Ram

[Rosen Vladimirov]

Hi Shiv Ram,

We are setting RadPivotGrid's IsBusy property internally based on the value of DataProvider's Status - if the Status is Initializing or RetrievingData, IsBusy property will be set to false. That's why you can use DataProvider's StatusChanged event to check the state of the DataProvider - if it is one of the mentioned, RadPivotGrid's IsBusy will be true. In all other cases IsBusy will be false.

Hopefully this helps. Feel free to contact us in case you have any other problems or concerns.

Regards,
Rosen Vladimirov
Telerik

[Shiv Ram Ameria]

Hi Rosen,

I am using DataProvider's StatusChanged event. When DataProvider's status becomes ready then only PivotGrid starts displaying data in PivotGrig and if DataProvider's ItemsSource is large data table, PivotGrid takes some time to display this data, here PivotGrid is still not ready (as its displaying data and showing wait window), but DataProvider's status is ready.

I wanted to attach a simple project, so you get more idea about what I want to achieve, but did not find option to attach zip files.

Thanks,
Shiv Ram

[Rosen Vladimirov]

Hello Shiv Ram,

As I've mentioned in your other thread, you can use DataProvider's BlockUntilRefresh method in order to block the thread until the DataProvider status became ready.

Hopefully this helps.

Regards,
Rosen Vladimirov
Telerik