You still need to add this component underneath "Components"
Some question about this component:
i can't seem to find method to :
1) initialize the component (tried all kind of methods)
2)Let the component call its GetPivotData again (tried all kind of methods)
Also
i save the state of the pivot, rows, cols and vals, all ok
But JQPivotUIOptions.AggregatorName is the one set initial , not the one set during the session, as is the RendererName
Strange, because all changes to the pivot happen clientside, that i can still read the proper rows, cols and vals! But not the AggregatorName and RendererName.
Also:
Trying to fill the pivot using GetPivotData i noticed that SuperObject.D('field') = FloatValue does not work, no error but also code does not execute , i now use SuperObject.I('field') = Round(FloatValue) as a workaround
more:
What is the best way to print this component
I have a TIWCGJQComboBoxEx on the form so i need to 'refresh' the pivot's data in the onChange of the combobox, i now use AjaxReRender but i wonder if there is not other method for this
I setup the component in the FormCreate:
- Code: Select all
pvtMain.JQPivotUIOptions.AutoSize:= True;
pvtMain.JQPivotType:= jqptPivotUI;
pvtMain.JQPivotUIOptions.GoogleChartRenderers:= True;
pvtMain.JQPivotUIOptions.D3Renderers:= True;
pvtMain.JQPivotUIOptions.RendererName:= jqprHeatmap;
pvtMain.JQPivotUIOptions.Cols.Add('Vendor');
pvtMain.JQPivotUIOptions.Vals.Add('Cost');
pvtMain.JQPivotUIOptions.Rows.Add('Product');
pvtMain.JQPivotUIOptions.AggregatorName := jqpaIntSum;
This works fine, but when i select a value from the combo that holds no data, the Pivot is ofcource empty. if i then select a item which has values, the Pivot is drawn but the Cols, Vals and Rows are not set in the pivot.
I also tried to re-fill it just before AjaxRerender but that does not work.
Eric